Forum Discussion

irfanelevated's avatar
irfanelevated
Icon for Helper II rankHelper 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

Need Help
  • selimovd's avatar
    selimovd
    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
     

2 Replies

  • selimovd's avatar
    selimovd
    Icon for Most Valuable Professional rankMost Valuable Professional
    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
     
  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    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.