Forum Discussion

thomaskelly's avatar
thomaskelly
Icon for Helper I rankHelper I
9 years ago
Solved

Unable to "Apply Query Changes".

Hello,   I merged two tables from a MySql connection in power query, however when i go to apply these changes the process times out and only reaches 6335 lines out of 800,000+ so a long way to go. ...
Need Help
  • thomaskelly's avatar
    thomaskelly
    9 years ago

    Hi Lydia

     

    I have rebuilt the data set from the ground up starting with all of the tables from one Sql server then making changes to these before introduction the tables from another sql server.

     

    This seems to have fixed the issue, and the report is refreshing in minutes when before just making one change in the query was taking hours to update.

     

    Thanks for you help and comments :-)

     

    Kind Regards

     

    Thomas

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi thomaskelly,

Do you use 32bit or 64bit Power BI Desktop? What is the timeout value you specify? Is there any possiblity that you import restricted columns and rows from MySQL to Power BI Desktop?

Regards,
Lydia Zhang

thomaskelly's avatar
thomaskelly
Icon for Helper I rankHelper I
9 years ago

Hi ,

 

I have changed the data load settings and un- ticked the load to report option on all but one of the query's, the remaining query has one column name change and one move column change. When I try to apply these changes to this one table I have the following running in the background.

 

2 x cefsharp.browsersubprocess.exe using 300mb of memory

4x microsoft.mashup.container.netfx40.exe using 400mb of memory

1 x power bi 300mb of memory.

 

this is a lot of resources for just one table effectively an done change ?

 

Kind Regards

Tom