Forum Discussion
Unable to refresh dataset - Error message
Hi bo_afk ,
I have found a similar psot, please refer to it to see if it helps you.
The amount of data on the gateway client has exceeded the limit for a single table.
Actually, the resolution of this issue is exposed in the Error message itself, remove the columns with high cardinality or move to Premium. The easiest way 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
ry to remove as much as you can from the columns that have the highest cardinality. In the above sample if we can remove “Order ID”, it will help reduce the size significantly.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi bo_afk ,
I have found a similar psot, please refer to it to see if it helps you.
The amount of data on the gateway client has exceeded the limit for a single table.
Actually, the resolution of this issue is exposed in the Error message itself, remove the columns with high cardinality or move to Premium. The easiest way 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
ry to remove as much as you can from the columns that have the highest cardinality. In the above sample if we can remove “Order ID”, it will help reduce the size significantly.
Best Regards
Community Support Team _ Polly
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous thanks for your suggestion.
What would be considered a "high cardinality"? I've checked my table and the highest cardinality column is 19,796.