Forum Discussion
Batch add rows via Logic App Connector?
Is your DataSet a real time streaming DataSet?
The Dataset for the Power BI connector in Logic Apps, PowerApps and Microsoft Flow currently only supprts RealTime Streaming Dataset.
If not, then the Add rows to DataSet will not work.
Regards,
Michael
To clarify, are you saying that you can only submit an array of objects to the connector if the dataset is a "RealTime Streaming Dataset"? (it seems in this case it is a PushStreaming dataset with historical data turned off? / When looking at the dataset online it's API Access field is "Streaming")
Assuming that is the case I gave it a shot:
The Dataset:
There is a single column, "Count", that accepts a Number.
Giving Payload a single object works fine:
but give it an array and you get the error:
This is the same error I got when I tried using PushStreaming, Push & Multi-Table Push datasets. They all work however if I only provide a single object.
I ran into an old powebi blog article which showed the connector accepting an array of objects:
I don't know if the devs reworked the connector somehow?
Thanks for the update.
The connector under Microsoft Flow seems to be updated.
The available DataSet listed are all streaming dataset, and the fields is generated automatically. So I am afraid the payload may not work at the current time.
You may consider add an apply to each loop in Logic Apps:
https://docs.microsoft.com/en-us/azure/logic-apps/logic-apps-control-flow-loops
Regards,
Michael
considering each call in a while/foreach loop counts as a Connector call, the maximum rate of rows I can push per second is ~1.6 rows per second, (100 calls / 60s) , which is laughably unscalable.. I guess I will have to code this solution after all.
(I would also suggest renaming the connector action to "add_row_to_dataset" as you cannot add more than one at a time).Thanks for your time
