Error loading HTML Dataset in Desktop

[Anonymous]

Link to error message  

I was trying to load a dataset with just 2 columns from Azure SQL Datawarehouse table:

Table contains just two columns and more than 5m rows.

InvoiceId (int,null)

Comment_Note (nvarchar (max,null)

Comment_Note is HTML column with up to 2.8m characters.

When I do an M query to load top 5,000 rows, it works fine and the PBIX created is just about 117KB.  

From rows 4,000 and above Comment_Note has 2.8m characters.

When I increase the number of rows selected to just 5,300, I get the following error messge:

Somethig went wrong.   Array dimensions exceded supported range.

Other details of the error  and all diagnostics are included in the attachment/Link.

Link to error message  

[v-frfei-msft]

Hi @Anonymous ,

1. Please follow this article to troubleshoot the issue: https://docs.microsoft.com/en-us/power-bi/desktop-error-launching-desktop

2. Please ensure your machine has Power BI desktop run on meet the minimum requirements: https://docs.microsoft.com/en-us/power-bi/desktop-get-the-desktop#minimum-requirements

3. Please restart the machine then run Power BI desktop again. 

[Greg_Deckler]

You could check the Issues forum here:

https://community.powerbi.com/t5/Issues/idb-p/Issues

And if it is not there, then you could post it.

If you have Pro account you could try to open a support ticket. If you have a Pro account it is free. Go to https://support.powerbi.com. Scroll down and click "CREATE SUPPORT TICKET".