Forum Discussion
The payload including configurations on activity/dataSet/linked service is large
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?
4 Replies
khush19 , did check for 75 columns,75 tables, and 120 request limitations? if that can be the reason
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.
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.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.
