Forum Discussion
Power Query suddenly refreshes very slowly
Hi,
I recently created some queries in Power Query that does many steps. Appends two tables together (live connection from Smartsheet) and merges that table (left outer join) with 4 other tables (Excel). These tables are all quite small (around 4000 records), and I had no issues refreshing it when I had first created the queries.
Then the next day, I tried to refresh it again, and it didn't work. I noticed that Power BI had created some relationships between some of my tables that caused the query to not work, so I deleted those relationships (they were not real relationships), but now when I refresh the queries it takes at least an hour to run (I have never actually sucessfully ran the queries after removing the relationships, as I've had to close Power BI at some point while they've been running, so it might not even work).
Is there something I should look out for that Power BI may have done to my query that might have caused it to stop working as expected?
Thanks!
Andrew
Hello Anonymous
this is always a challing task. Depending on how your queries are structured, queries are invoked multiple times. So putting a Table.Buffer in the right places can change the world. So for example when you are quering a Excel-file is large only 500 Kbyte, but when you are refreshing the previer it indicates multiple MByte, you already know that there is something wrong.
With a newer version of Power BI is the possibility to track every step and duration of it. You could try to enable this and check the result.
Hope it helps
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
Jimmy
2 Replies
Hello Anonymous
this is always a challing task. Depending on how your queries are structured, queries are invoked multiple times. So putting a Table.Buffer in the right places can change the world. So for example when you are quering a Excel-file is large only 500 Kbyte, but when you are refreshing the previer it indicates multiple MByte, you already know that there is something wrong.
With a newer version of Power BI is the possibility to track every step and duration of it. You could try to enable this and check the result.
Hope it helps
If this post helps or solves your problem, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
Have fun
JimmyHello Anonymous
Hello
have you been able to solve the problem with the replies given?
If so, please mark it as solution (to help other users find useful content and to acknowledge the work of users that helped you)
Kudoes are nice too
All the best
Jimmy