I have set up a "Flow" using the App to pick data from Microsoft Forms and live stream it to PowerBI.
Power BI has not streamed the old data from Forms: If a new survey is submitted the data is picked up, but the old survey results are not complete.
I thought that setting API connection will enable live streaming of data, not sure how to refresh the dataset to pull all the historical survey data?
Thank you in advance for the help and guidance
Do you create a push dataset or streaming dataset in Power BI?
If it's a streaming dataset, Power BI only stores the data into a temporary cache, which quickly expires. There is no underlying database, so we cannot build report visuals using the data that flows in from the stream. For more information, see: https://docs.microsoft.com/en-us/power-bi/service-real-time-streaming#streaming-dataset
Best Regards,Qiuyun Yu
Thank you for your response. Yes, it is live Streaming from "Forms", and Power BI picks up all the new submitted survey answers, but it is still missing some answers from previous submitted surveys.
Hope this makes sense now and provides a bit more insight?
Is there a option Historic data analysis available for the dataset? If not, it should be streaming dataset, we are not able to see it's historical data. Please go through the article I shared in my previous post again.