The payload including configurations on activity/dataSet/linked service is large

[khush19]

Hi ,

I have Push dataset ,where through ADF we PUSH data to POwerBI every 5 Mins.

while pushing to Powerbi when records are more than 2000 we get error "The payload including configurations on activity/dataSet/linked service is too large"

To resolve this i break the records and send 1000 rows each time.

I see we have limitaion mentioned https://docs.microsoft.com/en-us/power-bi/developer/embedded/push-datasets-limitations .

but what is this limitation?

[khush19]

To  solve this issue,I added foreach where I push 1000  rows to Power BI each time. and before also there was no parameter added ,it is just 6 columns with 3000 rows and it fails.

[v-henryk-mstf]

Hi @khush19 ,

For such error reporting messages. According to the explanation given in the official documentation: it may be caused by passing one or more large parameter values from the output of an upstream activity or externally, especially when passing actual data between activities in the control flow.

For more details, you can read related document.

General Troubleshooting - Azure Data Factory & Azure Synapse | Microsoft Docs

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,
Henry

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

[amitchandak]

@khush19 , did check for 75 columns,75 tables, and 120 request limitations? if that can be the reason

[khush19]

Thanks Amit  for reply,

but i checked my table is small with 6 columns.the only thing i can think of is azure-docs/azure-data-factory-limits.md at main · MicrosoftDocs/azure-docs · GitHub  

as data is transfered from ADF Web activity to POwerbi

so may be it is Web activity limitation,not sure though.