Forum Discussion
mmaster
6 years agoRegular Visitor
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...
camargos88
6 years agoCommunity Champion
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
mmaster
6 years agoRegular Visitor
Unfortunately this was not the case. The only query running is the one that PBI is asking to run when I go to apply changes.
- camargos886 years agoCommunity Champion
mmaster ,
Have you checked your database driver version ?
Also how is power bi consuming your memory ?
Ricardo