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...
Maggie77's avatar
Maggie77
Regular Visitor
4 years ago

Hi Lucien,

 

Thanks for your reponse.

 

I updated the Column Encryption field - but it displayed an error message 

 

  • bradsy's avatar
    bradsy
    Microsoft 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.