Import Streaming Dataset to regular dataset

[nsilv_le]

Team, 

I currently have a flow that will post a row containing a tweet sentiment score using the text analysis module by Azure. My question is I would like to make a report that would enable the user to access the data historically. I have tried changing the streaming dataset to a hybryd one by enabling the historical option however this will break the flow that I have in place. Is there a way to import the data from a streaming dataset to a regular dataset? This way I could build a report that would enable this functionality?

Kind Regards, 

Nathaniel

[lbendlin]

Not at the moment. There might be options to access the dataset via XMLA endpoint but that's not really helping you.

Why would enabling the history break your flow?

Also, could your flow post to a different storage engine?

[nsilv_le]

At the moment I can only upload data to a streaming dataset given the flow I'm using. I'm not sure if there is another way to upload data to a regular dataset instead of the streaming one. I am using the regular template provided by Power Automate. 

[lbendlin · Accepted solution]

If your Power Automate license supports premium connectors then you can stuff your data into a SQL Server table.  

Worst case you can stuff it into a sharepoint list. (yes, I know. That's why I said "worst case")