Extremely Slow Applying Query Changes while using Power BI Desktop connecting to Dynamics CRM online

Anonymous — Tue, 16 Oct 2018 18:53:20 GMT

Hello all,

I am developing reports/visualizations in Power BI Desktop connecting to Dynamics 365 CRM online. I am experiencing serious delay /extremely slow when applying query changes - endless and I have to cancel applying query change. Unable to progress.

I am sharing my major steps/information here and hope that somebody can help me with the reasons and solutions. Many Thanks.

I get data by connecting Dynamics 365 CRM online via OData feed- and selected Case (Incident) entity/ Query

I selected/chose 16 columns from hundreds of columns and rename some of them
I get data from 4 Excel files (less than 100 rows and small in size)
Then I applied Query Changes - it took hours and seems endless

There are about 1.06 GB data loading running endless and I had to cancel query chagnes. I checked in "Cases" Entity in CRM and there are over 8,000 case records.

My questions:

is this apply query delay in Power BI Desktop due to the huge amount of cases data loading ( like 8k + cases recrods in CRM) to Power BI?
I did some research online and I found related posting suggesting set-up Dynamics 365 Data Export Service, I wonder whether Data Export Service will be helpful for my case? And is Data Export Service a quick installation/configuration?

https://community.dynamics.com/crm/b/develop1/archive/2016/12/09/dynamic365-data-export-service

I am now trying to filtering the query to get a smaller data set of 100 case records (rather than 8k) so that I could apply query changes quicker and move on with my reports design, but it seems takes me longer time as well. All your helps will be appreciated. Thank you.

Re: Extremely Slow Applying Query Changes while using Power BI Desktop connecting to Dynamics CRM online

MiaZhao — Mon, 04 Mar 2019 22:34:47 GMT

Hi Anonymous .

I got the same issue, any luck on this?

topic Re: Extremely Slow Applying Query Changes while using Power BI Desktop connecting to Dynamics CRM online in Desktop

Extremely Slow Applying Query Changes while using Power BI Desktop connecting to Dynamics CRM online

Re: Extremely Slow Applying Query Changes while using Power BI Desktop connecting to Dynamics CRM online