Analysis service using SQL Server On-Prem

[Anonymous]

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 create measure.

For Ex : Table should display the ErrorTypeCode and the Count of each ErrorTypeCode

 

[v-janeyg-msft · Accepted solution]

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

[amitchandak]

@Anonymous , Can you click on see details and share the details

[Anonymous]

I'm getting the below error on clicking see details.