Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now

Reply
carrerab
New Member

Importing .csv data to streaming dataset

(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. 

0 REPLIES 0

Helpful resources

Announcements
November Carousel

Fabric Community Update - November 2024

Find out what's new and trending in the Fabric Community.

Live Sessions with Fabric DB

Be one of the first to start using Fabric Databases

Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.

Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.

Nov PBI Update Carousel

Power BI Monthly Update - November 2024

Check out the November 2024 Power BI update to learn about new features.