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
