Upload paginated report to D365 crm

[shaddy_w]

Hello experts,

I have developed some paginated reports using Dataverse and Azure sql database which are working fine in Power BI report builder but I am unable to upload it to the D365 crm environment like we upload Power BI dashboards to the D365 environment.

Thanks in advance.

[v-xiaoyan-msft]

Hi @shaddy_w ,

Does your connection string have an initial catalog? Would be the name of your environment without the crm.dynamics.com and should be added by Report Builder by default.

Best Regards,
Community Support Team _ Caitlyn

[shaddy_w]

Hi @v-xiaoyan-msft 

Thanks for the responce.

Yes the report that I have connected to CRM using dataverse have initialcatalog in the connection string and Organization name is with crm.dynamics.com and Azure Sql database connection string is "Data Source=environmentname.crm.dynamics.com;Encrypt=True;TrustServerCertificate=True;Authentication="Active Directory Interactive""

Thanks in Advance