Forum Discussion

Maggie77's avatar
Maggie77
Regular Visitor
4 years ago

PowerBI Report Builder - Dataverse

Hello, I am having problems displaying correct content when running a report using Dataverse - looking at displaying the Service Account, Customer Asset and System Status: eg. ABC Limited, B123456, O...
bradsy's avatar
bradsy
Icon for Microsoft Employee rankMicrosoft Employee
4 years ago

The issue does not look to be about encryption. I think the issue might be "msdyn" tables are system tables and the columns you chose look to be some type of ID, not description. I am not familar with the schema, but you probably want to find the details table and possibly join the two tables together so that you get the correct "serviceAccount" name for the "msdyn serviceAccount" identifier.

Maggie77's avatar
Maggie77
Regular Visitor
4 years ago

Thanks Bradsy, that does seem logical.   I am fairly new to this so will check out how to join the relevant tables together.