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.

 

I have devloped the dashboard before using the same data from the MYsql connection but downloaded into Csv files and the merge and updating worked fine, however I now want to remove thi setp and have a direct link.   When i remove the merge step the data refreshes fine.

 

Any suggestions would be most welcome.

 

Many Thanks

 

Tom

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

12 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    I have seen this in Oracle too. The problem was that the data type in the columns I merged were different types. When I changed the data types in theese columns to the same (Number) then the merge went may times faster.

     

    Regards
    Aslak

  • 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

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    I apologize if this is repetitive (I am not a developer/programmer - a wannabe).  This question seems similar to mine, but my error was the result of creating a query with multiple excel files (FY11-FY19) in a folder.  Can you explain what the issue is and how I can fix it?

     

     

    • idkwhatimdoing's avatar
      idkwhatimdoing
      Advocate I
      2 years ago

      check that the tabs are consistent in their naming convention in each workbook AND that it's what it was named when you intially set it up. othewise, open your navigation steps and make corrections