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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

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
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

Find out what's new and trending in the Fabric Community.