Query table BusinessUnitMap

(1) Share

Report

Posted on by VeraVB

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?

kind regards,

Vera

Categories:

Microsoft Dynamics CRM

All responses (1)

Answers (1)

Verified answer

VeraVB 9 on at

Like (0)

Report

Query table BusinessUnitMap

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.