How to create a report in Power bi Report builder using dynamics 365 fetch

[Aakash137]

Hi , 

I am trying to build a simple report using power bi report builder but when I am adding a data source then I am not able to find a connection type of dynamics 365 (like dynamics 365 fetch) to create a connection between dynamics 365 and power bi report builder.

I just want to create a report using fetch xml downloaded from advance find like we generaly create a report in ssrs using authering extension tool.

I have attached a ss here:

[bradsy · Accepted solution]

Hi Aakash137,

FetchXml is not directly supported. You should be able to use the Dataverse connector and create a TDS based SQL query.