Hi
Was asked to assist with setting up a user to allow them to build Charts using Power BI using the Dynamics 365 F&O data, so I set them up with an Odata connection between Power BI and Dynamics 365 F&O.
Using the Azure>Dynamics 365 Legacy connection type.
They then queried why they only see a small amount of the data in some tables when they use them, an example is projectposttrans.
When I looked this I could see if was only pulling data for the entity the user is assigned to and changing them from one entity to another in the System administor> Users section would alter the data they where able to pull :
The problem is the user wants to make global charts (our setup is broken down into entities per region and the business is spread across the globe)
My question is there a way to retrieve this data so its not entity specific?
Cheers;
Median
