Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
I am accessing our Dynamics 365 data but pulling in data from the tables is extremely slow. I could probably watch an entire baseball game while it updates a few tables. And it not like we have tons of rows. Does anyone access Dynamics CRM via PowerBI and can show an example of the connector you use and how you use it? Maybe I am connecting to the data but in the wrong way. Thanks!
I use XRM Toolbox (XRM Toolbox link) to generate FetchXML queries to extract data from Dynamics 365 as I can use filters to restrict the number of records extracted (eg date after xx/xx/xxxx and in region AAA only).
However, FetchXML queries will also get slow if all-attributes is used to query column information. By default, all-attributes will be used if more than 17 columns are requested. Some workaround and manual updating of the FetchXML query will be needed if you need to extract more than 17 columns in one query, but there is a very tangible 3-4x improvement in refresh time by not using all-attributes.
XRM Toolbox (Power Query (M) Builder to be more exact) presents the tables and columns in a much easier to navigate interface compared to the built-in connector, and allows you to quickly find and select the columns you want.
Also, if you have a predefined report/view on Dynamics 365, Power Query (M) Builder can use that view to generate FetchXML to extract the same columns and also combine the filters used to generate the view - definitely a time-saver.
Hi @Razorbx13 ,
Here's an article detailing how Power BI connects to Dynamics CRM Data, you can refer to the steps:
How to Connect to Dynamics 365 Data from PowerBI Desktop | PowerObjects
There's a workaroud in this similar thread is to export the data to an SQL Server/Azure SQL database and then query against that.
Hope it helps!
Best Regards,
Community Support Team _ kalyj
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Check out the November 2025 Power BI update to learn about new features.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
| User | Count |
|---|---|
| 104 | |
| 81 | |
| 69 | |
| 50 | |
| 46 |