Import & Export Query to avoid recreate visual of 9 pages

[Kaalu007]

Hi Friends, 

i have 2 .pbix file

1) 1st .PBIX file, having many visuals for almost 9 pages, with filters, colors, font, formatting in it.

2) 2nd .PBIX file is Fresh file importing data from 15 Queries from single source.

- each query keeps specifice columns, then do transformation, columns additon 

- then each query is appended into one

- appended query is now new master of my 2nd .PBIX file

Now, what i need is, is to make 1st.pbix file but my source would be different i.e. 2nd.pbix file.

How can i achieve this, what are options available or tips or trick, i need to follow.

[Kaalu007]

Can't install DAX Studio due to organisation restriction, if DAX can solve i will try but need details steps for same.

[danextian]

Hi @Kaalu007 ,

You can export that appeneded table (loaded into the model) from the 1st pbix as a csv using a tool like DAX Studio. The export will be as you see in the data view which includes calculated columns but not measures.  Then you can use the exported file as the data source of your 2nd pbix. So you create a copy of the 1st pbix, keeping the visuals, etc but change the data source of your query to the csv file making sure that you keep the columns and column names originally loaded into the model.