Gateway has exceeded the limit for a single table.

[Samy-Elsayed]

Kindly advice,

I received the message when I check why the refresh failed:

(The amount of data on the gateway client has exceeded the limit for a single table. Please consider reducing the use of highly repetitive strings values through normalized keys, removing unused columns)


this dashboard has a small table and refreshes one time every day, I have another dashboard that has big tables with huge data and refreshes much time in the day and works with no issue 

[v-tangjie-msft]

Hi @Samy-Elsayed ,

You should check this as following.

Firstly, about whether the premium is set correctly. There are various sku premiums and they have different limits on the size of the dataset .

Secondly, make sure that the workload behavior of premium capacity is configured correctly in the admin portal.

service admin premium workloads 

Thirdly, enable large dataset in power bi permium. Large datasets in the service do not affect the Power BI Desktop model upload size, which is still limited to 10 GB. Instead, datasets can grow beyond that limit in the service on refresh.

Fourth, as the error message says, reduce the use of highly constant, long string values and instead use a normalized key. Add a primary key and move most of the calculations to DAX to limit datasets size, or refer to the method described in this article (How to Minimize Data Load Size for Tables in Power BI ).

Best Regards,

Neeko Tang

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

[Samy-Elsayed]

Thanks for you answer

i dont have primum gateway

i have this 

[v-tangjie-msft]

Hi @Samy-Elsayed ,

You can purchase Power BI Premium and refer to the method in the above reply to solve the problem. You can also solve the problem by limiting the size of the dataset without purchasing.(Refer to the method in Article 4 above)

To purchase Power BI Premium , you can refer to the documentation: How to purchase Power BI Premium - Power BI | Microsoft Learn

Best Regards,

Neeko Tang

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

[Samy-Elsayed]

It's not solution, i ask about the technical solution to avoid this issue

[v-tangjie-msft]

Hi @Samy-Elsayed ,

Do you mean to increase the gateway limit on a single table?This is by design.

You can post your idea to Ideas . https://ideas.powerbi.com/ideas/

You can refer to the above four methods to avoid errors.

Best Regards,

Neeko Tang

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