Forum Discussion
PowerBI/Query are suddenly (!) extremely slow when trying to access ODBC database (PBI Desktop)
Hi, everyone, firstly many thanks for all the support and ideas, which are shared in this community. I was a silent reader for nwo two years and learnded a lot from this. Now, comming to our pro...
Hello Haruo_online ,
2 things come to my mind that could cause query folding to break although you didn't change the M-code:
- Mismatching privacy levels: If you combine different sources in your SQL query you must ensure that they have the same privacy level settings. I've experienced some weird behaviour where privacy levels in the service changed seemingly automatically. Could be because one of the sources was used in a different dataset that used that different pricacy setting. But it's definitely worth checking.
- When you are using non-SQL sources in an inner join, that could bite you as well: SQL-query folding bug still alive and sucking in PowerBI and PowerQuery in Excel – The BIccountant
Dear Imke,
thanks for your considerations - I am afraid they don't meet the source of the problem thow:
- I am starting with a blanc, fully new PBI report
- then, I try to open an ODBC table - one which I am frequently using in other PBI reports
- and then it can take between minutes and up to several hours, just to see the preview of that file.
The SQL-statement I was talking about is a statement created automatocally by PBI/PQuery when I try to open this table and the only way to see it is looking to what arives at the database.
☹️
Heino