cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Rookarumba Regular Visitor
Regular Visitor

Apply Query Changes : Taking too long , like hours or so

Hi Everyone,

 

My "Apply query changes' is taking far too long. This wasn't the case when I was working on the same dataset (2m rows) of data.

 

Recently I did some changes and removed some of the steps within the query that required Merged.

 

And now when I apply changes to it, is taking forever and seem like is stuck at loading a particular query and it wont move beyond it.

 

Additional Information

I import all my data into PowerBI via Excel and did all the query within PowerBI.

18 REPLIES 18
Rookarumba Regular Visitor
Regular Visitor

Help for Apply Query Changes

Hi Everyone,

 

My "Apply query changes' is taking far too long(more than 2 hours). This wasn't the case when I was working on the same dataset (2m rows) of data.

 

Recently I did some changes and removed some of the steps within the query that required Merged.

 

And now when I apply changes to it, is taking forever and seem like is stuck at loading a particular query and it wont move beyond it.

 

Is there anyway to improve the performance of my query?

 

Additional Information

I import all my data into PowerBI via Excel and did all the query within PowerBI.

Community Support Team
Community Support Team

Re: Help for Apply Query Changes

Hi Rookarumba,

 

Query in power query is slower than database. It is not recommended to implement queries on big data frequently in power bi. As a workaround, you can do these operations in database.(e.g.: merge(join), append(union all)).

 

Regards,

Jimmy Tao

Rookarumba Regular Visitor
Regular Visitor

Re: Help for Apply Query Changes

Unfortunately, i don't have the luxury of having a database since the files are data dump by another source.

 

Thus I'm using PQ to work on those data on a Quarterly basis.

 

The weird thing is, i work on a previous copy and it seem fine, just not sure why this copy doesn't work after i edited some of the M  codes

dmb33875 Regular Visitor
Regular Visitor

Re: Help for Apply Query Changes

I am having a similar issues where I am attempting to load a query from an analysis services connection.  The report says it has loaded 970k rows which soulds reasonable, but it seems to be hung up in finishing the job.  I've been watching the load for about 45 minutes and am hesitate to walk away for fear that it will time out.  Once I get the initial load in I can apply some filters to better scale the data, but I just need to finalze the data connection.  My first instinct was to load everything then scale back, but I suppose the next attempt is to load limited data then ramp up.  Any other suggestions for a relative novice/non-programmer?

Rookarumba Regular Visitor
Regular Visitor

Re: Help for Apply Query Changes

@dmb33875 , 

 

my current workaround is rewriting the queries with R instead of M.

So instead of waiting for up to 2 hours for the queries to finish loading, R can finish the job within 15 mins.

 

Hope this help

dmb33875 Regular Visitor
Regular Visitor

Re: Help for Apply Query Changes

Thanks for the info.  I have not yet done queries in R but will investigate.  

t_phi Visitor
Visitor

Re: Apply Query Changes : Taking too long , like hours or so

Hi everyone,

 

In my case, I have a very simple SQL query which should return around 60k rows of data. But it took hours for me to get over the "Apply query changes" page.

 

I'm connecting to a database via ODBC. I have tried to uncheck the "Auto Date/Time" in the Options > Data Load settings. But it doesn't help that much. Any advice on how to make it faster? Maybe some setup/configuration that I might have missed?

 

Thanks!

dataguy9980 Frequent Visitor
Frequent Visitor

Re: Apply Query Changes : Taking too long , like hours or so

I'm in the same boat.

 

Trying to pull data out of Filemaker 16 Server via ODBC.  A refresh on 1 table of 50k rows takes 2-3 hours ... not acceptable for my client/solution.

 

Anyone have any suggestions?

melissd Frequent Visitor
Frequent Visitor

Re: Apply Query Changes : Taking too long , like hours or so

Same thing here. I have a joined query that is taking toolong (>1hr) to retrrive 6.6M. 

Helpful resources

Announcements
Community Highlights

Community Highlights

Find out what's new in the Power BI Community!

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Virtual Launch Event

Microsoft Business Applications Virtual Launch Event

Watch the event on demand for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Users Online
Currently online: 93 members 1,425 guests
Please welcome our newest community members: