How to solve uncompressed data size specified in a packet header exceeds limit of 8.5 MB

[Sowjanya_1]

I am having some 100 workspaces in my power bi service.All the reports in 99 workspaces are working as expected but in one workspace for some reports i'm getting below error.

Without compression algorithm, the uncompressed data size specified in a packet header exceeds limit of 8.5 MB. Please reduce the size of column data values within the transformed result-set to below 8.5 MB.

[Idrissshatila]

Hello @Sowjanya_1 ,

go to power query, and check this table with the column having the error and see why its so complex.

maybe its the data type.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Sowjanya_1]

Hi @Idrissshatila ,

Thanks for the reply,how to find which column is causing error because i haven't created any new column other than those imported from redshift.

I created some measures to get expected result will that cause this error?

[Idrissshatila]

Hello @Sowjanya_1 ,

you try to refresh every table seperatly in Power query and the table with the error will be flagged out with what is the error.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Sowjanya_1]

@Idrissshatila it is in production environment,i don't have access to refresh the tables.
Is there any other way to find the root cause?

[Idrissshatila]

Hello @Sowjanya_1 ,

you should get a copy of the pbix file to check where's the error coming from and solve it.

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin

[Sowjanya_1]

I don't have access to connect to production tables from power bi desktop.

I'm seeing this issue in only production environment,for other environments it is working as expected.