Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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")
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?
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.
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")