Forum Discussion
Solved
Change Data Source but Keep Models and Visualizations
Hello, I am using DirectQuery to get data from a data warehouse that we built that we are constantly making updates to. We currently have a single data warehouse that we are connected to, made mo...
I like this approach for automation, thanks for suggesting the approach. For manual updates I just use the Change Source dialog in Data Source Settings:
I don't know why Microsoft has implemented it that way. There are a couple of other data as well (like formatting for example) that don't come with the standard Power Query-import.
Only thing you can do is to hack the Excel-file and re-assemble the xml to the table's content: https://github.com/ImkeF/Power-Query-Excel-Formats
But that might get very cumbersome (no support on that from me here currently).
I've written about this method here: https://www.thebiccountant.com/2017/08/18/how-to-import-from-excel-with-cell-coordinates-in-power-query-and-power-bi/