Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi,
Unable to refresh the data at PowerBI services getting the below error-
Any help would be appreciated 🙂
Thanks,
Irfan
Solved! Go to Solution.
Hey @irfanelevated ,
it seems like the amount of uncompressed data on the gateway client has exceeded the limit of 10 GB for a single table 😉
You have to make your data model smaller. Remove columns you don't use, take DAX Studio and use the Advanced --> View Metrics feature and check which columns take a lot of space and remove them if you don't need them or improve them. For example use numbers as IDs instead of strings, disable the automatic time intelligence and if you have columns with the format DATETIME split them into date and time and use 2 dimensional tables for your analysis.
Hello @irfanelevated ,
Not sure about your current subscription. If you are a Pro user, 10 GB is your limit as per the subscription limitations. So you need to either increase your subscription to the next level or reduce the data size. Below is the screenshot of the limitations you can refer to.
Let me know if this helped you.
Regards,
MBM.
Hey @irfanelevated ,
it seems like the amount of uncompressed data on the gateway client has exceeded the limit of 10 GB for a single table 😉
You have to make your data model smaller. Remove columns you don't use, take DAX Studio and use the Advanced --> View Metrics feature and check which columns take a lot of space and remove them if you don't need them or improve them. For example use numbers as IDs instead of strings, disable the automatic time intelligence and if you have columns with the format DATETIME split them into date and time and use 2 dimensional tables for your analysis.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.