Forum Discussion
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, Open-Scheduled:
Any feedback would be greatly appreciated.
Thank you
6 Replies
Hi Maggie77 ，
Do you enable the Advanced option "Column Encryption Setting" ? That will decrypt your data.
Using SQL Server Always Encrypted data in Power BI Report Builder (Paginated Reports)
Did I answer your question? Mark my post as a solution!
Best RegardsLucien
Hi Lucien,
Thanks for your reponse.
I updated the Column Encryption field - but it displayed an error message
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.
Thanks Lucien - bit deep for me.
