Forum Discussion
Difficulties Retreiving Data from Dynamics
I have been having some extreme difficulties loading data into Powre BI from Dynamics. Some small tables will load into Power BI after maybe 5 or 10 minutes, but larger tables (60,000 - 150,000 rows)...
After an arduous investigation with Microsoft data architects, what we found here was:
1) In your queries, only include fields that you know you will need (use the Remove Columns functionality, or code the M-code fetch). This will obviously cut down on the amount of data to be fetched.
2) Make sure your Dynamics tables are indexed, this will decrease fetch times.
3) Hunt down fields that are glitchy (we determined that a particular field in a table was very glitchy and yielded the overwhelming majority of the load time, as the fetch process for that field was erroring out).
Using these methods, we were able to cut our data refresh times from (30 minutes to indefinite) down to about a minute.