Forum Discussion
Import Streaming Dataset to regular dataset
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
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")
3 Replies
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?
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")