cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gckcmc Member
Member

timeouts for SQL Analysis Services (client side)

I see this thread:

https://community.powerbi.com/t5/Desktop/Query-Timeout-on-update/td-p/53459

 

does anyone know what the code would be for SQL AS entries?  I tried these options, but the syntax isn't recognized.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: timeouts for SQL Analysis Services (client side)

hmm, that documenation is not very clear on that. When it says "A duration" it means a literal "duration" data type for PowerQuery. You can create one using the #duration( <days>, <hours>, <minutes>, <seconds>) constructor.

 

So if you wanted a 2 and a half minute timeout you would do the following:

 

= AnalysisServices.Database("mycompany.com", "DatabaseName", [TypedMeasureColumns=true, Implementation="2.0", CommandTimeout=#duration(0,0,2,30) ])

 

 

View solution in original post

4 REPLIES 4
Super User
Super User

Re: timeouts for SQL Analysis Services (client side)

It depends what function you are using to pull the data from SSAS. If you are using AnalysisServices.Database() you should be able to specify the CommandTimeout property (see https://docs.microsoft.com/en-us/powerquery-m/analysisservices-database)

gckcmc Member
Member

Re: timeouts for SQL Analysis Services (client side)

So I'm using that interface.  However, no matter what value I choose, I get the "DataSource.Error: AnalysisServices: This function doesn't support the query option 'CommandTimeout' with value XX

 

= AnalysisServices.Database("mycompany.com", "DatabaseName", [TypedMeasureColumns=true, Implementation="2.0", CommandTimeout=2])

 

I've used a ton of different values, as the documentation doesn't specify if it's minutes, seconds, ms, or other.  Used with and without quotes as well to confirm.

 

I'm wondering if the server-side is blocking attempts to override the value?

Super User
Super User

Re: timeouts for SQL Analysis Services (client side)

hmm, that documenation is not very clear on that. When it says "A duration" it means a literal "duration" data type for PowerQuery. You can create one using the #duration( <days>, <hours>, <minutes>, <seconds>) constructor.

 

So if you wanted a 2 and a half minute timeout you would do the following:

 

= AnalysisServices.Database("mycompany.com", "DatabaseName", [TypedMeasureColumns=true, Implementation="2.0", CommandTimeout=#duration(0,0,2,30) ])

 

 

View solution in original post

gckcmc Member
Member

Re: timeouts for SQL Analysis Services (client side)

Thanks!  I'd seen that documentation for non SSAS types, however it wasn't working when I tried it.  There seems to be another format that syntactically is taken, but errors out.  (single number vs. the 4-ple style you list.)

Helpful resources

Announcements
October 2019 Community Highlights

October 2019 Community Highlights

October was a busy month in the community. Read the recap article to learn about some of the events and content.

New Badges

Incoming: New and Improved Badges

Exciting news: We've given our badges an overhaul and added brand news ones.

Ask Amir Anything

Exclusive LIVE Community Event No. 2 – Ask Amir Anything

Next in our Triple A series: Ask Amir Netz questions about the latest updates, features and future.

Analytics in Azure virtual event

Analytics in Azure virtual event

Experience a limitless analytics service built to ingest, prep, manage, and serve data for immediate use in Power BI.

Users Online
Currently online: 334 members 3,189 guests
Please welcome our newest community members: