cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
viditachudasama
Frequent Visitor

Scheduled Dataset Refresh Failed

Hi,

A Scheduled Refresh failed for 6 out of 7 datasets with Error Code : DMTS_StandAlone_UserErrorTooManyRequest, I have posted the error details of one of the datasets,

Data source error:

{"error":{"code":"DMTS_StandAlone_UserErrorTooManyRequest","pbi.error":{"code":"DMTS_StandAlone_UserErrorTooManyRequest","exceptionCulprit":1}}} Table: TenantList.

Cluster URI:

DF-MSIT-SCUS-redirect.analysis.windows.net

Activity ID:

7ce671ff-4ef8-4900-a65e-18ab620ae0bc

Request ID:

04027f9e-ff32-4914-afce-6d88b89593c6

Time:

2021-07-16 17:04:22Z

 

0b8d83a4-5c56-45c5-88bb-27f95efdb026.png

However, All the other refresh after that succeeded.

1 ACCEPTED SOLUTION
viditachudasama
Frequent Visitor

I have enabled the "large dataset storage format" option for the datasets and I haven't received refresh failure messages after this change.

View solution in original post

4 REPLIES 4
viditachudasama
Frequent Visitor

I have enabled the "large dataset storage format" option for the datasets and I haven't received refresh failure messages after this change.

View solution in original post

v-xulin-mstf
Community Support
Community Support

Hi @viditachudasama

 

Are you still experiencing this problem after retrying?
When reporting a refresh failure error message, please check if you can access the data source normally.

You can also refer this similar post, hope it helps!

If you still have some question, please don't hesitate to let me known.‌‌

 

Best Regards,

Link

 

Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution. Really appreciate!

GilbertQ
Super User II
Super User II

Hi @viditachudasama 

 

If you had to reduce the tenantlist table to say one tenant does it then refresh?

 

If it does you no w know where the issue is and try different ways to resolve this?





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

Proud to be a Super User!







Power BI Blog

Greg_Deckler
Super User IV
Super User IV

@viditachudasama You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




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

Proud to be a Super User!




Helpful resources

Announcements
PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Get Ready for Power BI Dev Camp

Microsoft named a Leader in The Forrester Wave

Microsoft received the highest score of any vendor in both the strategy and current offering categories.

Get Ready for Power BI Dev Camp

Power BI Dev Camp - September 30th, 2021

Mark your calendars and join us for our next Power BI Dev Camp!

PowerPlatform 768x460.png

Microsoft Learn

Check out our new Discover Your Career Path blog post series and get all the details.