cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
jsquaredz Regular Visitor
Regular Visitor

Service data refresh is timing out

So I created a query in PowerBI Desktop.  The data source takes a while to return back the query response (Web request returning JSON), so I add this to the query string in Desktop;   [Timeout=#duration(0,0,30,0)]

 

This works great.  I never get timeouts with this setting in place and the data comes in eventually.

 

I published this data source and report to the Office 365 PowerBI  Pro Service, and set the autorefresh.  Unfortunately, I get an failure after some amount of time.  I do not believe that the Timeout parameter is being used in the Web version.  I am unable to edit the query in the service, but if I copy and paste it out, I see there is no Timeout parameter.  

 

Really need this to work.  My whole project hinges on this.

Helpful resources

Announcements
GregDeckler

How to Get Your Question Answered Quickly

Power BI Super User, Greg Deckler, explains

Summit North America

Power Platform Summit North America

Register by September 5 to save $200

Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Top Ideas
Users Online
Currently online: 6 members 1,168 guests
Please welcome our newest community members: