Forum Discussion
How to create an upsert dataflow?
Situation: Source data needs to be upserted into a destination table. Prefer to use only Power Bi/ Power Platform SaaS tools Prefer to avoid using Azure services Prefer wysiwyg tools I can pu...
To the best of my knowledge what you want to do is not possible at this moment in time with Power BI or Power Platform DataFlows. The best solution is to consider using Azure Data Factory, that would allow you do what you are asking for.
Thanks for the reply. It is quite disappointing to hear. I hope that others may know of a way. Thank you for providing me with a direction to investigate. 😀
As a rule of thumb, Power BI is just for reading data, not for updating data sources. Good luck; ADF is a powerful toolset that does some fantastic things. We have built solutions similar to the one you describe using ADF.