Error processing the data in the dataset - Exceeds the maximum size limit

Hello Anonymous ,

try to optimise your report.

check this article https://www.linkedin.com/pulse/power-bi-optimization-framework-ahmad-chamy-nensf/

Hi Anonymous ,

First of all, many thanks to Idrissshatila  for your very quick and effective replies.

You could try below steps:

1. Consider Using DirectQuery: Since you're currently using the "Import" option, switching to "DirectQuery" could be a viable solution. DirectQuery doesn't import data into Power BI; instead, it queries the underlying data source in real-time. This means the size of your dataset on disk won't be a limiting factor.

2. Optimize Your Data Model: If sticking with the "Import" option, consider optimizing your data model to reduce its size. This could involve removing unnecessary columns, aggregating data at a higher level, or using incremental refresh to only load data that has changed.

3. Incremental Refresh: For Premium workspaces, you have the option to use Incremental Refresh, which allows you to refresh only the data that has changed, rather than the entire dataset. This can significantly reduce the amount of data processed and stored. To learn more about setting up Incremental Refresh, visit Incremental refresh in Power BI.

Best regards,
Community Support Team_Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.