Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Query change keeps spinning on OK button.

I have a couple of oracle sql queries that I have been using without too much trouble.   But, when I go make a change, it's been taking longer and longer to come back from the Power Query.    I've tr...
Need Help
  • Anonymous's avatar
    Anonymous
    2 years ago

    I reworked the queries and it helped a lot

AbhinavJoshi's avatar
AbhinavJoshi
Icon for Responsive Resident rankResponsive Resident
2 years ago

Hi Anonymous .

 

In general I would recommend doing filtering in the SQL Query itself, it will save you time in processing. Also, I would recommend running query diagnostic on your steps in Power Query. You can find it in Power Query -> Tools -> Start Diagnostic. It will tell you how much time a step takes. Let me know if it helps. 

 

Thanks,

Abhinav