Convert SQL Based table into a local table

[thejav]

I have a Query that creates a table from a SQL Server table. I wold like to sever this relationship and make the table a local table, that is a table that is not refreshed and that i can edit and add data right in PowerBI. How can i do this?

Thanks, thejav

[camargos88]

Hi @thejav ,

You can load the data once and stop the refreshes.

This link can help you: https://stackoverflow.com/questions/42070677/what-do-enable-load-and-include-in-report-refresh-mean-...

After that, you can create another table with your data and append it to the SQL table:

https://www.excelinppc.com/merge-vs-append-in-power-bi-in-power-query-editor/

Just the edit part that can be an issue, but perhaps you can create a new table and replace the values using merge functions.

Ricardo