Forum Discussion
Getting an error while refreshing power bi report.
Hi Anonymous ,
It should be by-design limitation. Actually, the resolution of this issue is exposed in the Error message itself, remove the columns with high cardinality or move to Premium.
Move to Premium:
With Premium capacities, large datasets beyond the default limit can be enabled with the Large dataset storage format setting. But it's cost is high.
Therefore, you can try to remove the columns with high cardinality.
Please follow the steps to find the columns with high cardinality is to use the DAX Studio tool:
1 Connect to the model/PBIX file
2 Go to Advanced -->View Metrics
3 Try to remove as much as you can from the columns that have the highest cardinality.
Please reference the following links which may be helpful to you.
The amount of data on the gateway client has excee... - Microsoft Power BI Community
Large datasets in Power BI Premium - Power BI | Microsoft Learn
Best Regards,
Community Support Team _ xiaosunIf this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous
It's abvious that your Data model needs optimisation. If you don't want to go for Power BI Premium because of its cost then for sure you need to verify the size of your tables. Maybe use Direct Query mode is also a good solution.