cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Regular Visitor

Convert SQL Based table into a local table

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

1 REPLY 1
Super User III
Super User III

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



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Helpful resources

Announcements
Community Conference

Power Platform Community Conference

Check out the on demand sessions that are available now!

Community Conference

Microsoft Power Platform Communities

Check out the Winners!

secondImage

Create an end-to-end data and analytics solution

Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.

Top Solution Authors
Top Kudoed Authors