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

Shape the future of the Fabric Community! Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions. Take survey.

Reply
Don-Bot
Resolver I
Resolver I

How can I change the timeout of a dataset with XMLA Endpoint? Tabular Editor?

I have a dataset that I want to reduce the timeout on.  It has been set to a 5 hour timeout and I would like to reduce it to an hour and a half.  

 

I connected to the dataset with Tabular Editor and attempted to change the timeout there.  However, today it is still timing out at 5 hours.  Did I miss something?  Here is where I edited it in tabular editor.

 

DonBot_0-1700057054266.png

 

2 REPLIES 2
v-junyant-msft
Community Support
Community Support

Hi @Don-Bot ,

Please try modifying the dataset timeout in Power Query in Power BI Desktop instead of in Tabular Editor.

You can refer to the methods in these two posts, which I have tried myself and are effective:
Solved: Query Timeout on update - Microsoft Fabric Community
How to extend Power BI service timeout limit - Microsoft Fabric Community

Best Regards,

Dino Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Thanks @v-junyant-msft , I was trying not to do this in power bi desktop and was using Tabular Editor due to these being large datasets setup with incremental refresh.  So if I make these changes in desktop and upload I'll have to refresh everything again...  

Although if there isn't an alternative I may have to bite the bullet and do it...  

 

I did find in Tabular Editor where I can do the M Code in the first link above.  And even though I made that change it didn't work.  So I may just have to reupload and refresh things again sadly....

 

 

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

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

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.