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?
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:
Just the edit part that can be an issue, but perhaps you can create a new table and replace the values using merge functions.
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.