I am trying to refresh a dataset but getting the following error:
"The amount of data on the gateway client has exceeded the limit for a single table. Please consider reducing the use of highly repetitive strings values through normalized keys, removing unused columns, or upgrading to Power BI Premium."
I found an similar issue with similar refresh errors. 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. 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
3 Try 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.