Forum Discussion

bo_afk's avatar
bo_afk
Post Patron
4 years ago
Solved

Unable to refresh dataset - Error message

Hi, I'm getting the error message below when I try to refresh one of my datasets in PowerBI service. I've re-published the report and it works but I'm just unable to refresh it. The PBIX file is "onl...
Need Help
  • Anonymous's avatar
    Anonymous
    4 years ago

    Hi bo_afk ,

    I have found a similar psot, please refer to it to see if it helps you.

    The amount of data on the gateway client has exceeded the limit for a single table. 

    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

    ry 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.   

     

    Reference: https://docs.microsoft.com/power-bi/connect-data/refresh-troubleshooting-refresh-scenarios#uncompres...

     

    Best Regards

    Community Support Team _ Polly

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Hi bo_afk ,

To make the refresh works again, reducing the use of highly repetitive, long string values and instead using a normalized key or removing the column (if not in use) will help.

If you don't want to reduce anything in your pbix, you could consider upgrading to Power BI Premium where you can have more storage and function.

https://powerbi.microsoft.com/en-us/power-bi-premium/

 

If you are using Power BI Premium,please try to Enable large datasets.

  1. Create a model in Power BI Desktop. If your dataset will become larger and progressively consume more memory, be sure to configure Incremental refresh.

  2. Publish the model as a dataset to the service.

  3. In the service > dataset > Settings, expand Large dataset storage format, click the slider to On, and then click Apply.

     

  4. Invoke a refresh to load historical data based on the incremental refresh policy. The first refresh could take a while to load the history. Subsequent refreshes should be faster, depending on your incremental refresh policy.

More details:Enable large datasets 

 

I have also found a similar post, please refer to it to see if it helps you.

Premium account : The amount of data on the gateway client has exceeded the limit for a single table 

  • Settled with Large dataset storage format

If it does not help, please provide more details with the error.

 

Best Regards

Community Support Team _ Polly

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

bo_afk's avatar
bo_afk
Post Patron
4 years ago

Hi Anonymous , thanks for the response and info.

I am able to publish the report with the same dataset and current size (after refreshing locally on desktop), should I be able to refresh the dataset in PBI Service with no issues either? 

 

Additionally, I have other reports in the same workspace which are much bigger than this and they have been able to refresh successfully.