Forum Discussion
Move PowerBI Streaming data to ...? Dataflow?
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 response...
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