Forum Discussion
Failed to refresh dataflow after changing underlying data
- 6 years ago
Hi lbendlin ,
You are getting error : The"xxx"column does not exist in rowset, is it right? It is by design, modifiying the structure of a data source will cause this problem. You need to republish it. For more details, please refer to https://community.powerbi.com/t5/Issues/Error-when-refreshing-dataset-based-on-a-dataflow-entity-with-a/idi-p/622074#comments
Best Regards,
Dedmon Dai
Hi lbendlin ,
You are getting error : The"xxx"column does not exist in rowset, is it right? It is by design, modifiying the structure of a data source will cause this problem. You need to republish it. For more details, please refer to https://community.powerbi.com/t5/Issues/Error-when-refreshing-dataset-based-on-a-dataflow-entity-with-a/idi-p/622074#comments
Best Regards,
Dedmon Dai
Ok, so its not a bug but a feature?
One would imagine that using edit on a dataflow entity to update and refresh the data would also save the eventual changes.
Imagine deploying a self-service BI structure to an enterprise wide Power BI organization and having to update each and every dataset and app with the new source parameters.
If what you are saying is true then one would have to make sure that the underlying table in the source never changes or youll be in a heap of administration problem updating all the dependencies.
I thank you for your reply and will mark it as the solution. Even though i wouldve hoped to have this acknowledged as a bug.