Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply

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.

 

vikrantarora25_0-1627975288487.png

 

5 REPLIES 5
v-yangliu-msft
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:

 

vyangliumsft_0-1628145482305.png

 

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

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors