PowerBI Report Builder - Dataverse

[Maggie77]

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

[v-luwang-msft]

Hi @Maggie77 ,

Pls refer the following article ,and check if it is helpful:

https://techcommunity.microsoft.com/t5/azure-database-support-blog/lesson-learned-13-sql-server-inst... 

Best Regards

Lucien

[Maggie77]

Thanks Lucien - bit deep for me.

[v-luwang-msft]

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 Regards

Lucien

[Maggie77]

Hi Lucien,

Thanks for your reponse.

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

[bradsy]

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]

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