Error Message; Data in the preview has been truncated due to size limit.

Question

I have connected my Microsoft Access to Azure. When trying to get results from Power BI within Azure, I got an error message that reads: "...data in the preview has been truncated due to size limit." Please advise how to overcome the error message.

Answer 1

This you answer, didnt help at all, there is no where to Adjust the limits for maximum rows in Data load in Current file

Answer 2

If you face similar situation, it will be best to convert you data to CSV

Answer 3

Hi Jose Guerrero,

Thanks for reaching out to Microsoft Q&A.

You might face this error when working with large datasets. This error occurs because the amount of data returned by your data source is too large for PBI to display in the preview window. Hence, only a portion of the data is shown, and the remaining data is truncated.

You might have to consider...

Increase Data Load Limits: Navigate to File > Options and Settings > Options > Current File > Data Load in PBI. Adjust the limits for maximum rows and maximum size. However, be cautious when increasing these limits, as it may impact system resources.

Filter the Data: Filter the data returned by your data source to reduce the amount displayed in the preview window. Use options like Filter Rows or Remove Rows in the Transform Data menu to exclude unnecessary data. Utilize the filter pane or create a measure with a filter expression to further refine the data.

• Always try data model option when dealing with large datasets in PBI. It allows you to create relationships between tables and summarize data, reducing the amount of data loaded into memory.
• Also explore using Group By or Aggregate in the transform Data menu to summarize data before loading.

Please 'Upvote'(Thumbs-up) and 'Accept' as an answer if the reply was helpful. This will benefit other community members who face the same issue.