The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
(apologies in advance if this posted twice - i had to create an account to post and then it took me to an alternate page without confirming it had posted, and i hadn't seen it in the forum)
Hello, my company is interested in migrating from our third party survey vendor for customer feedback to MS Forms in order to easily integrate with Power BI and create a live dashboard of customer satisfaction. I believe I understand creating the streaming dataset and corresponding Flow from the Form (used this video https://www.youtube.com/watch?v=O9Izx6f2734 for reference) which is great for live data. Going forward, we plan to send this survey out to clients and move away from our paid service.
However, we are still interested in reporting on historical data, trends, etc., so we wish to bring in all of the old data from our survey to date into that same dataset. I am very confused when it comes to pushing the .csv data to this newly created streaming dataset. Most of the solutions I've found require scripting, which is fine, I just can't for the life of me figure out which process I should be following. It seems that each time I find something promising, there's one detail about it that I don't think is applicable in my situation. If anyone could provide any insight/links to help me narrow down my search, that would be wonderful. Or, if I'm going about this all wrong and should simply dump the data then configure a Flow from Forms to add to it, that would be good to know, too. I only saw the streaming dataset example and thought it was applicable.