Forum Discussion

MP_123's avatar
MP_123
Microsoft Employee
10 years ago

error on importing data

hi   i attached print screen of the error when i trying to import data of my ssas. is someone know what's the problem? i have 64bit version and also enough memory. when i choose other attribute t...
Need Help
v-qiuyu-msft's avatar
v-qiuyu-msft
Community Support
10 years ago

Hi MP_123,

 

According to your description, you are able to connect to SSAS database to get data, but when you add a measure or column in Power BI Desktop, the error throws out, right?

 

Based on my research, the issue can be caused by an incorrect memory setting in SSAS. In your scenario, please make the memory settings change to give a proper value to the memory limits in either percentage of server memory, or in bytes. For more information, please refer to this article:

 

SSAS error “The operation has been cancelled because there is not enough memory for the application” when there is still a lot of memory available


If you have any question, please feel free to ask.

 

Best regards,
Qiuyun Yu

  • MP_123's avatar
    MP_123
    Microsoft Employee
    10 years ago

    v-qiuyu-msft

    the memory settings you meant, is on my computer ? or on the SSAS ?

    PBI desktop doesnt have size limits right? the limit is only when publish?

    • v-qiuyu-msft's avatar
      v-qiuyu-msft
      Community Support
      10 years ago

      Hi MP_123,

       

      The memory settings mentioned in orignal post is on SSAS server. You can open Analysis Server Properties to modiffy those preperties.

       

       

       

      Best Regards,
      Qiuyun Yu