Forum Discussion
Online refresh is failing : Compressed DataSize For Packet Exceeded
Need Help: Manage storage is showing dataset size is 37 MB and the overall size is 10 GB. but online refresh fails with the following error: "Data source error: {"error":{"code":"DM_GWPipeline_Gatew...
We had the same error message and found out that it was due to large text fields in our file.
We had cleaned up HTML text fields in SQL before bringing in to Power BI where we realised that we had brought both the cleaned up column and the HTML one. Each column contained approximately 20 million characters.
We removed the HTML column from the table in Power BI after selecting transform data and re-publishing the desktop file. This worked for us and we still hold a file with one column that contains around 20 million characters that has been refreshing successfully.
Hope this helps!