Hello everyone,
I am a finance professional and an absolute beginner with database and access. :-)
I would please need your help regarding my project: I am trying to consolidate data from multiple entities in my group around the world, and then make dashboards on Power Bi out of it. This database needs to be user-restricted, meaning for instance User A in Australia will be able to only see the Australian data in the database while entering/updating it. As data needs to be updated regularly, I would like to avoid any copy paste as possible and would like the user to update directly the main database. Hence will the dashboards on PowerBI automatically be updated in real time without my intervention.
We have office 365. I hope my explanations are clear enough
Thank you very much for your help
Pierro