How to connect with Dynamics 365 system view from Paginated Report Builder or AAS

[avdutta]

Hi,

I am trying to extract and display the Dynamic 365 (services) system views and display in Power BI Paginated report bulider and then schedule it as pdf. But I am unable to figure out any way to the views in AAS or in Power BI Paginated report bulider. I can get the fetchxmal from savedquery table, but then how to automatically execute that fetchxml to get the report.

Please help.

Regards,

Avijit

[v-piga-msft]

Hi @avdutta ,

By my tests and research, I'm afriad that there is no fetchxml connection in Power BI Report Builder currently.

As a workaround, I think you could extract the Dynamic 365 (services) system views to the data sources below which are supported and then get the Dynamic 365 system views in power bi report bulider.

Best Regards,

Cherry

[avdutta]

Is there any way that I can execute/extract the dynamics system views in AAS and then from AAS I could take those into paginated report builder.