Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

Analysis service using SQL Server On-Prem

Using analysis service with live connection i have 23 million records. I'm trying to visualise the data with table and also I want to count the occurence of element in the table. I'm not able to cr...
  • v-janeyg-msft's avatar
    4 years ago

    Hi, Anonymous 

     

    The error message shows that you seem to have downloaded the 32-bit version of Desktop.

    You can download the 64-bit version of Desktop to see if it has issues.

    Download Microsoft Power BI Desktop from Official Microsoft Download Center

     

    If it is due to insufficient memory, you can increase the memory, or try to filter part of the data when connecting.

    Increasing the Maximum allowed to 16000 under Desktop/ File / Options and Settings / Options / Global / Data Load.  Data Cache Management Options.

     

     

    Did I answer your question ? Please mark my reply as solution. Thank you very much.
    If not, please feel free to ask me.

     

    Best Regards,
    Community Support Team _ Janey