Showing results for 
Search instead for 
Did you mean: 

Fabric is Generally Available. Browse Fabric Presentations. Work towards your Fabric certification with the Cloud Skills Challenge.


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




Community Support
Community Support

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

Super User
Super User

@vikrantarora25 , more information is needed.

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

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

@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

@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?

Helpful resources

PBI November 2023 Update Carousel

Power BI Monthly Update - November 2023

Check out the November 2023 Power BI update to learn about new features.

Community News

Fabric Community News unified experience

Read the latest Fabric Community announcements, including updates on Power BI, Synapse, Data Factory and Data Activator.

Power BI Fabric Summit Carousel

The largest Power BI and Fabric virtual conference

130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.

Top Solution Authors
Top Kudoed Authors