Forum Discussion

irfanelevated's avatar
irfanelevated
Helper II
5 years ago
Solved

Unable to refresh the data

Hi,   Unable to refresh the data at PowerBI services getting the below error-   Any help would be appreciated πŸ™‚   Thanks, Irfan
  • selimovd's avatar
    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 regards
    Denis