Is there a way to copy paste a BI file and change just the data but still have the visuals and formu

[Anonymous]

Is there a way to copy paste a BI file and change just the data but still have the visuals and formulas there? 

I have for example one file built for company A and want to have exactly the same for company B - but of course the data differs between them.  How do I do that smooth?

[Icey · Accepted solution]

Hi @Anonymous ,

Try to save the BI file built for company A as a template file(.pbit). And then, open the .pbit file and connect to the data of company B.

Power BI report templates contain the following information from the report from which they were generated:

• Report pages, visuals, and other visual elements
• The data model definition, including the schema, relationships, measures, and other model definition artifacts
• All query definitions, such as queries, Query Parameters, and other query elements

What is not included in templates is the report's data.

Reference: 

Create report templates for Power BI Desktop;

What is the difference between .pbix and .pbit ?

Or, you can go to Advanced Editor and change the source code.

Best regards

Icey

If this post helps, then consider Accepting it as the solution to help other members find it more quickly.

[amitchandak]

@Anonymous , change the connection details, using edit connections.

or open the file is data transformation mode. right click on the table open advance editor and change the connection details

https://www.youtube.com/watch?v=9rgbKcHz6ug

https://www.youtube.com/watch?v=_8dJ--ktU4c

https://www.youtube.com/watch?v=mqoV-CRegp8

[Anonymous]

Hello sir,

hmm.. but I it is the same drom

the data base but I just want to change the query.

all this is change the data base? I just want to change the query