Unable to publish to web

[shabrez]

Hi All,

I need help in publish the dashboard as it says file is too large to publish.

PFA Attached

[Idrissshatila · Accepted solution]

Hello @shabrez ,

Please look for and remove columns that have lots of text in them.

Notes fields are a big killer of performance and increases in pbix file size.

Remove columns that are not useful for reporting and analysis.

For more information, you can refer to this : https://www.fourmoo.com/2019/11/27/how-i-saved-40-on-my-power-bi-dataset-size/

You can also follow this article if you need：https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques　

Hope it helps.

[xifeng_L · Accepted solution]

Hi @shabrez ,

You can reduce the dataset size by limiting the number of rows returned using parameters in PowerQuery. Such as:

Then, when you publish to the Server, change the query parameters in the dataset setting to return all the data, so you can bypass the 1G size limit at the time of publishing.

Did I answer your question? If yes, pls mark my post as a solution and appreciate your Kudos !

Thank you~

[Idrissshatila · Accepted solution]

Hello @shabrez ,

Please look for and remove columns that have lots of text in them.

Notes fields are a big killer of performance and increases in pbix file size.

Remove columns that are not useful for reporting and analysis.

For more information, you can refer to this : https://www.fourmoo.com/2019/11/27/how-i-saved-40-on-my-power-bi-dataset-size/

You can also follow this article if you need：https://blog.pragmaticworks.com/power-bi-performance-tips-and-techniques　

Hope it helps.