Edit a MS Forms streaming dataset to Power BI

kky1 — Wed, 10 Apr 2024 20:12:59 GMT

Hello - I created a MS Forms and Power BI dashboard with a direct connection via the API to the MS Form responses dataset. Recently, the office hosting this MS Form made changes to the form that is now affecting the data to look wonky in slicers etc. because they have multiple choice questions and included commas in the response, which is separating the categories incorrectly.

I now need to edit the streaming dataset that I set up initially so that the data comes through accurately, but I cannot figure out how to do this. All my searches show how to set this up but not how to edit or update the connection. If I create a new API connection to the form, I'm afraid it will lose all the historical responses which is not helpful. Can anyone assist with my question?

kky1

Re: Edit a MS Forms streaming dataset to Power BI

lbendlin — Wed, 10 Apr 2024 22:38:38 GMT

You're out of luck with this one. You can only push rows into a streaming dataset. You cannot modify any of the data once loaded/pushed.

Re: Edit a MS Forms streaming dataset to Power BI

kky1 — Tue, 16 Apr 2024 12:11:39 GMT

Thank you for letting me know - you at least saved me the time to keep investigating if this was possible.

topic Edit a MS Forms streaming dataset to Power BI in Developer

Edit a MS Forms streaming dataset to Power BI

Re: Edit a MS Forms streaming dataset to Power BI

Re: Edit a MS Forms streaming dataset to Power BI