Forum Discussion

Rookarumba's avatar
Rookarumba
Icon for Helper III rankHelper III
8 years ago

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 th...
Need Help
laggerok19's avatar
laggerok19
Frequent Visitor
7 years ago

The same thing here. I confirm the bug exist as of 28-Sep-2018.

 

We have <10 non live data sources each extracting just ~20 rows from Tabular models my means of DAX. Extracts themselves happens in ~1 minutes in parallel, but union them into common dataset takes 12-15 minutes, while should be few seconds.

 

Do you know whether bug request was raised for this?

  • Rookarumba's avatar
    Rookarumba
    Icon for Helper III rankHelper III
    7 years ago

    laggerok19 , I'm not too sure if this is a bug but is more on how PowerQuery is refreshing the query when some changes are done on it.

    As of today, I'm using a method suggested by Ken Puls (I can't remember what is the name now but i can search for it and post it here again) so the queries won't evaluate everytime.

     

    Also, I've upgraded my RAMs to 32GB and that reduces the queries timing from hours to 15 mins Max.

     

    If you can, I suggest you update your RAM too :)

     

     

    • laggerok19's avatar
      laggerok19
      Frequent Visitor
      7 years ago
      Rookarumba, this happens when you refresh data at the point of time when combined data set is refreshed. Data extracts are quick, but not union operarion. Im not even saying about data transformations.

      We have 8 gb RAM to union ～120-150 rows. Completely not applicable performance for application that cost that money.

      What is the way suggested? If that it to publish pbx to pbi reporting service and do scheduled refresh, its not our case. SLA mins are 10 min.