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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
Don-Bot
Helper I
Helper 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
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Power BI Header Change

Power BI Header Update

Read about the exciting updates for the Power BI forum.

Top Solution Authors
Top Kudoed Authors