Product:
Power BI Dataflow
Issue:
After user account is changed (owner), the dataflow is not updated. (this is only when you use a Power BI gateway to access SQL database on prem.)
Solution:
You have on the dataflow gone to settings, and change the owner to a other person. (by press the Take Over button)
On the dataflow tab go to EDIT
Click EDIT on one table.
You get a error message, that it can not contact SQL server.
Click on OPTIONS icon.
Click on project and data load, and change the data gateway to one in the dropdown list.
Click OK.
Now the table should be refreshed automatic, and you can save and close the dataflow.
More Information:
https://learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-configure-consume
https://learn.microsoft.com/en-us/power-query/dataflows/data-sources?tabs=power-bi-service