Forum Discussion
Helper IUnable to "Apply Query Changes".
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
Helper IHi Lydia
Thanks for this. I have tried and it has increased the timeout but not solved the issue.
I am connecting to a MY SQL connection the merge itself is ok , when try to expand the column's the process slows to a near halt. But using the same data in CSV files is not a problem.
I am perplexed!!
Kind Regards
Thomas
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
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
- thomaskelly
Hi
Using a 64bit version , I have set the timeout at 8 hours and there are no restricted columns ... I have cut everything back and still no luck....
Kind regards
Thomas
thomaskelly,
I would recommend you check that if you can increase query timeout or connection timeout value on MySQL server side.
Regards,
Lydia- thomaskelly
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