Insert/Delete into Database From Power Query ✨ | CRUD Operations into Database Using Power query 💫✨

[@djenral6153]

Thanks a lot... CRUD with Invoke custom function..... Brilliant version.....!

[@PowerBIHelpline]

Thanks for the feedback

[@mirrrvelll5164]

I am today year old knowing this! wow and wow! Genius!

[@PowerBIHelpline]

Glad to know you found it so useful.👍

[@alankarsrivastava5328]

Invoke function Not working in schedule refresh pls suggest

[@PowerBIHelpline]

Schedule refresh is just a scheduler to completely refresh your dataset .do you mean to say "Incremental refresh"??

[@naldi525]

Hi hello, how if the text with quotes insert to sql? '"&Text.From([text_with_quotes])&"' I found an error when insert it.

[@ramrn8988]

Hi, I have tried this method and updated the sql table initially but later it stopped working, when I approach power bi community, they replied as it's not recommended step, to writeback to sql, we need to use VBA instead.

[@PowerBIHelpline]

Writeback from Power BI either through Power App or from Power query editor is not recommended for a high volume, these writebacks can be used for some special purposes, and for a proper ETL operations you should use ETL tools.