Forum Discussion
Transfer Result Table to next Model
thanks for your suggestion. Data Security is not much of a concern to me as of yet.
I think i found the solution, though!
If i do not start from an empty pbix but already have some kind of local model (i.e. one table) then I can pick and choose which table are imported (including the relations between them).
On the left you see a small local table, on the right 2-3 tables from 6 different remote models that all have a lot more tables.
This is just what I wanted!
If I now want to add calculated columns to those new tables, the Microsoft Documentation says that I have to use "make changes to this model" which does not appear for me in this scenario. I assume that this is because I only loaded a part of the model ?
Wow...all theses different import modes are really complex to wrap your head around...live vs direct query, with or without local copy of the remote model. Anybody have a good resource that sums it all up ?