Forum Discussion
Copy layout from power bi file
Ah, OK this is a different problem really then. So, if you are NOT using a Direct Query (Live) connection, then your best bet would be to use the Advanced Editor in the Query Editor to simply change the data source. Then everything will work perfectly as long as your table and column names are the same. So, what you generally do is to go into Query Editor and create a new query to your new target data source (SSAS). You go into Advanced Editor and copy the Source line and possibly the Navigation step as well. Then you go to your original query, open Advanced Editor and replace your Source and possibly Navigation step(s).
And what to do if I am using Direct Query ( Live connection ) ?.
Since Power Bi Services is a Live Connection, the Analysis Services also has to be a Live Connection.