Query load stuck

[vikrantarora25]

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 but navigating thru the cube to fetch required columns.

[v-yangliu-msft]

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

[amitchandak]

@vikrantarora25 , more information is needed.

under option and setting -> option increase cache size and try

[vikrantarora25]

Thanks @amitchandak Let me try increasing cache size from 4096 MB to say 1.5 GB, and what additional details can i provide you.

[amitchandak]

@vikrantarora25 , when the first time saw the post there was no text or image, I can see now. The question is can it be a live connection (AAS)

Seem like you are importing

[vikrantarora25]

@amitchandak yes am importing and import usually from AAS cubes is seamless but 1st time  facing this issue. Should I wirte a DAX query to pull data from AAS cube, I believe that's more efficient than navigating the cube in PBIX, will that help or you suggest something else?