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 to iomport sometimes the error is transaction failed or something like that..

there is no problem on live connection but in this way i can't add measurs\columns

 

thank you very much for your help!

Need Help

3 Replies

  • 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