Forum Discussion

vikrantarora25's avatar
vikrantarora25
Icon for Helper I rankHelper I
5 years ago

Query load stuck

Hi Folks, I'm sourcing data from AAS cube and query is stuck for a long period, I have set command timeout to 2 hours still no luck. Any suggestions?   I'm not using DAX/MDX to query the cube bu...
Need Help
Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi  vikrantarora25 ,

Do you choose "Import" or "Live Connection" mode to connect to the SSAS database in Power BI Desktop?

In order to improve the performance during connection, please turn off the following options in Options and Settings -> Data Load, and then refresh the data model:

 

 

Best Regards,

Liu Yang

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