Power Automate - Add Rows to Dataset

[00lduncan]

I have been using Power Automate to populate a Streaming Dataset in Power BI with data from Microsoft Forms.

When i complete this form with the details for some Streaming datasets the payload field is replaced with the headers of all the values from the stream. But on other (seemingly identical streaming datasets, stored in the same place and createdi n the same way) it just has the payload field. Can anyone help, it would be much easier if they all populated with the headers!

Thanks,

Laura

[sailochanar]

Can we create a flow to automatcially upload csv or excel files in a new power bi desktop or service ??

[lbendlin]

Yes, that's what a semantic model refresh does.

[Anonymous]

Give it a try this way at the payload field:

{

"columnName":"dynamicValueHere",

"secondColumnname":"dynamicValueHere"

}

i know this is manual way but at least should make it work if you can't get it the other way around.

Cheers,

Idlir

[00lduncan]

Thanks for your help, unfortunately I still get an error message:

I've only managed to successfully connect one List from Microsoft Sharepoint to Power BI using Power Automate. It looks simple but i think there is a glitch.

[nksse]

I'm experiencing the same issue. I've selected my workspace and dataset, but I only get a 'Payload' input field to set the values of all columns of the row. The xpected behaviour is that Power Automate loads the columns from the dataset and lets me set the value for each column.

I'm expecting to see something like this:

but only see this (payload):

I hope this makes sense. Thanks in advance

[TanTianAn]

Hi nksse,

A bit late but I replicated your issue - you can skip the payload JSON option when you allow your streaming dataset to allow Historical Data Analysis. It's this option right at the bottom of Edit Streaming dataset.

[MarksmanWaugh]

@nksse did you ever solve this? I am experiencing the same.

[lbendlin]

Are you trying to add rows to a regular dataset? That won't work. You can only insert rows into push datasets.

[RealSir]

Hi, maybe silly question, but is there a way to remove rows the same way?

[lbendlin]

Not at the moment. For now your only option is to blank out the entire dataset.  Flush and fill, basically.

[RealSir]

That's even better, how i can do that in one flow?

[lbendlin]

Push Datasets - REST API (Power BI Power BI REST APIs) | Microsoft Docs

This lists the required calls to flush streaming datasets.

[lbendlin]

Your question is not clear (to me). Can you please elaborate?