Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
@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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
102 | |
48 | |
19 | |
13 | |
11 |