Microsoft is giving away 50,000 FREE Microsoft Certification exam vouchers. Get Fabric certified for FREE! Learn more
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?
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.
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.
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.
Check out the April 2025 Power BI update to learn about new features.
Explore and share Fabric Notebooks to boost Power BI insights in the new community notebooks gallery.
User | Count |
---|---|
102 | |
68 | |
46 | |
37 | |
37 |