Forum Discussion
Unable to refresh the data
- 5 years ago
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.
If you need any help please let me know.If I answered your question I would be happy if you could mark my post as a solution βοΈ and give it a thumbs up πBest regardsDenisBlog: WhatTheFact.biFollow me: twitter.com/DenSelimovic
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.