topic PowerBI Report Builder - Dataverse in Report Server

PowerBI Report Builder - Dataverse

Maggie77 — Thu, 21 Apr 2022 02:38:28 GMT

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

Re: PowerBI Report Builder - Dataverse

v-luwang-msft — Mon, 25 Apr 2022 01:57:54 GMT

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

Re: PowerBI Report Builder - Dataverse

Maggie77 — Tue, 26 Apr 2022 00:53:00 GMT

Hi Lucien,

Thanks for your reponse.

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

Re: PowerBI Report Builder - Dataverse

v-luwang-msft — Tue, 26 Apr 2022 01:49:47 GMT

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-instance-in-use-does-not-support/ba-p/368831

Best Regards

Lucien

Re: PowerBI Report Builder - Dataverse

Maggie77 — Tue, 26 Apr 2022 03:13:33 GMT

Thanks Lucien - bit deep for me.

Re: PowerBI Report Builder - Dataverse

bradsy — Tue, 26 Apr 2022 20:08:34 GMT

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.

Re: PowerBI Report Builder - Dataverse

Maggie77 — Wed, 27 Apr 2022 04:26:34 GMT

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