Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
woogie
Frequent Visitor

Dataset udate issue in browser

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

 

woogie_0-1672203248618.png

woogie_1-1672203266477.png

 

2 REPLIES 2
FarhanAhmed
Community Champion
Community Champion

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...







Did I answer your question? Mark my post as a solution! Appreciate your Kudos!!

Proud to be a Super User!




@FarhanAhmed 

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

 

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors