failed to refresh data in pbi service when data set over 1gb?

[oakfootballclub]

hi experts, is it a limitation of size of the dataset to be refreshed in pbi service?

any solution to it?

[Anonymous · Accepted solution]

Hi @oakfootballclub ,

Yes, there is indeed a size limit for datasets that are refreshed in Power BI Services. For datasets imported into Power BI Services, the maximum size of the semantic model is 1 GB.

You can consider the following ways to solve the problem:

1. Filter out unnecessary columns or rows before importing data into Power BI to reduce the amount of data to be imported.
2. If the dataset size frequently exceeds the shared capacity limits, consider migrating to Power BI Premium to eliminate these limits, thereby allowing larger dataset sizes and more frequent refreshes.

Best Regards,

Ada Wang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.