Dynamics 365 System Views on Power BI

[dllanto]

Hi, 

When I try to get data from Dynamics 365 it only shows data table in the navigator. I want to be able to select "System Views" when choosing tables. How do I find personal "System Views" on the navigator when getting data from Dynamics 365 online?

[v-yuezhe-msft]

@dllanto,

You can use web connector in Power BI Desktop to connect to the Dynamics 365 view. Before that, you would need to intergrate FetchXML query into the web url, for more details, please take a look at the following blog.

https://community.dynamics.com/crm/b/crmchap/archive/2016/11/27/powerbi-deep-dive-using-the-web-api-...

Regards,
Lydia