Forum Discussion
Stuck on Apply Query Changes
Good day, I've created a report with 12 queries-- 11 from ODBC sources (all BPFIN, various tables within), and one which is a merge of all of the rest. When I click "Ciose and Apply" Power BI att...
Hi mmaster ,
I faced a situation like that, in my case I had a lot of queries submitted from PBI to the database. It had a query running forever on the database and it was locking all the others queries, after kill that session it was ok (I just solved it changing the sql and add an index to the database).
Can you check it ? Also, check your code running on database directly.
Ricardo
Ricardo
Maybe you can take a look at the following links:
Referenced Queries And Caching In Power BI And Power Query
How and When to use List & Table Buffer?
I hope this Helps!
Regards,
Lewis