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
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
5 years ago

vikrantarora25 , more information is needed.

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

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

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's avatar
    amitchandak
    Icon for Super User rankSuper User
    5 years ago

    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's avatar
      vikrantarora25
      Icon for Helper I rankHelper I
      5 years ago

      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?