when i refreshed dataset in desktop version, it does work.
but in browser, there is some conflict in dataset.
is there any way to fix this problem ?
+ uncheck "unsing parallel query" is complete
Few things can be checked
- Is your ODBC driver a "System DSN" or "User DSN" ? This should be System DSN
You are getting error -2147467259 which is
-2147467259 Error ODBC Microsoft Access Driver: The database has been placed in a state by an unknown user that prevents it from being opened or locked.
PRB: Error -2147467259 When You Try to Open the Same MDB File from Multiple Instances - Microsoft Su...
Then you have Presto error Query failed (): Too many queued queries for “xxxxxxxxx”
If your queue size was 50 though, you would have 25 running queries, 50 queued queries, and 25 queries would fail with a note about resources being exceeded on the cluster like this:
REf: Presto Resource Groups Practical Notes | Coding Stream of Consciousness (coding-stream-of-consciousn...
Proud to be a Super User!
thanks for comment !
it has 19 queries in dataset and each has approximately 3,000 row maximum.
even if only different thing is a version (desktop, browser), could it be a matter of queue size?
it does works in desktop version
Take a look at the September 2023 Power BI update to learn more.
Join Microsoft Reactor and learn from developers.