Move PowerBI Streaming data to ...? Dataflow?

[shawngoicoechea]

I am new to the community, but I did search around here and online in general without much success. Sorry if this is obvious.

I use Flow to make a streaming data set in PowerBI from form responses.  However, after doing some visualizations I realized that there are some problematic limits to the Streaming Dataset for my purposes.  

Is there a way to make a dataflow from multiple streaming datasets in PowerBI?  I want to blend data submitted via two forms.  Having them be "real time" is not a big deal - I can hit the refresh button a few times a day and that is "real time" enough for my purposes.

Essentially I'm annoyed because I just want to migrate data from a couple forms with a shared key into a data type that I can make dashboards from in PowerBI.

Thank you in advance to any and all who answer.

[TomMartens]

Hey,

unfortunately it's not possible to convert a streaming dataset into any other kind of dataset.

But maybe you use Office Forms to capture the responses, then you could use Excel to capture the responsed.
Put these Excel file(s) on onedrive for business.

Source these Excel files with Power BI Desktop, if you publish the report into a Power BI App workspace, you can schedule refresh. As you mentioned that realtime is no big deal, you can schedule a refresh up to 8 times using Power BI Pro licensing.

As you have a multiple Excel files with the same shared key, you can stich these Excel files (becoming tables in your Power BI model) together.

Hopefully, this provides you some ideas.

Regards,

Tom