The data in the preview has been truncated due to size limits

[Anonymous]

The data in the preview has been truncated due to size limits"

my excel file currently is of 9.8mb and when I load I get this error, how to resolve this and load the data successfully?

Thanks

[Anonymous]

Hi @Anonymous ,

What did you do to get this error message? When connect to Excel file in Power BI Desktop?

Best Regards

[Anonymous]

Hello @Anonymous 
You can refer to this link 

[Anonymous]

Thanks but this is not for exporting the data out.

[amitchandak]

@Anonymous , If you talking about power query. You are always shown the first 1000 records.

You can scroll and get more.

I discussed a part of it in this -https://www.youtube.com/watch?v=1_XlyzV-PcY

[Anonymous]

@amitchandak this is not about power query, this is uploading an excel file to power bi or pulling the excel datasource. How to resolve the error?

[Syndicate_Admin]

Were you able to solve the problem?