Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Connection between MS Forms <-> sharepoint <-> PowerBI datasets

Dear,    We collect Pareto data in our company every morning in order to be able to cascade up important points in the collaboration. The work sequence is approx. like this: 1) Employees ...
General Comment
Tips and Tricks
  • christinepayton's avatar
    christinepayton
    2 years ago

    Yes, you can do things to the form that will break the Power Automate flow that sends the data from Forms to SharePoint. Power BI references the fields in the list by name, so if you rename fields in the list that will also break things. This is the annoyance of dealing with less rigid data structures - it's a thing. You can fix it by going back and updating references in your query steps, but it can happen for sure. The most common thing to go wrong is the refresh will fail.

     

    You can reduce the likliehood of breaking things by not giving broad access to a lot of users to change the form or the list. 

christinepayton's avatar
christinepayton
Icon for Most Valuable Professional rankMost Valuable Professional
2 years ago

Yes, you can do things to the form that will break the Power Automate flow that sends the data from Forms to SharePoint. Power BI references the fields in the list by name, so if you rename fields in the list that will also break things. This is the annoyance of dealing with less rigid data structures - it's a thing. You can fix it by going back and updating references in your query steps, but it can happen for sure. The most common thing to go wrong is the refresh will fail.

 

You can reduce the likliehood of breaking things by not giving broad access to a lot of users to change the form or the list.