Forum Discussion

thomaskelly's avatar
thomaskelly
Helper 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,

Specify appropriate value in “Command timeout in minutes (optional)" following steps below, then check if you can refresh successfully in Power BI Desktop.

1. Click on the arrow for "Edit Queries" in your current Power BI Desktop file, select "Data Source Settings” in the dropdown.
2. Click on "Change Source..." in the Data source settings pop-up window.
3. Click on Advanced Options in the pop-up window, enter 60 minutes in the "Command timeout in minutes (optional)" textbox, then click OK.

Alternatively, you can directly add CommandTimeout in Advanced Editor as shown in the following screenshot.

 

Thanks,
Lydia Zhang

thomaskelly's avatar
thomaskelly
Helper I
9 years ago

Hi 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

  • 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
      Helper 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

    • thomaskelly's avatar
      thomaskelly
      Helper I
      9 years ago

      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

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        thomaskelly,

        I would recommend you check that if you can increase query timeout or connection timeout value on MySQL server side.

        Regards,
        Lydia