Forum Discussion
600 Second Timeout Setting?
etuckeriv - Are you really sure that you need to download Analysis Service cube data into Power BI model? You could be better off using SSMS or DAX Studio to integrate the data, or importing the data from Source. If from Power BI dataset, extract too much data could exceed CPU and memory limits leading to poor performance.
The following will increase the timeout from 600 seconds to 900 seconds. Note #duration( day, hour, minute, seconds)
Source = AnalysisServices.Database( #"Server", #"Database", [Query="MDX or DAX String", ConnectionTimeout=#duration( 0, 0, 15, 0 ) ] )
Hello!
Thank you for your reply! I'll do my best 🙂
When I go to "Get Data" I chose "SQL Services Analysis Database" to access the data cube where my data is located. I don't know if this matters, but I am also using the "Import" functionality instead of "Connect Live".
I don't know how to write queries yet, so to get around that I have figured out that I can build a table of the data I need from the ENORMOUS dataset I'm connecting to, then run the Performance Analyzer tool and "Copy Query Code" from there to write the query I need to pull that specific data. So I built a table of the data I want, copied the query code, and I've connected to the database URL and pasted that copied query code into the "MDX or DAX query (optional)" section.
I hope all that makes sense. Let me know what other info you might need, and thank you again!
etuckeriv - Are you really sure that you need to download Analysis Service cube data into Power BI model? You could be better off using SSMS or DAX Studio to integrate the data, or importing the data from Source. If from Power BI dataset, extract too much data could exceed CPU and memory limits leading to poor performance.
The following will increase the timeout from 600 seconds to 900 seconds. Note #duration( day, hour, minute, seconds)
Source = AnalysisServices.Database( #"Server", #"Database", [Query="MDX or DAX String", ConnectionTimeout=#duration( 0, 0, 15, 0 ) ] )