Via XRMToolbox, I can query table businessunitmap. However if I want to use the generated MQuery to connect in Power BI, I get a message the table does not exist.
I also tried using odata, connection to SQL server, dataverse, nothing works.
There is also no information to be found about this businessunitmap.
It's a table that MS uses for security of records.
Does anyone have experience with this strange and as it looks hidden table?
FYI: The table is available via ADF, you can then dump the content in a SQL server database and then connect to this database with Power BI.
Was this reply helpful?YesNo
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
9
Share
Report
All responses (
Answers (
