Forum Discussion

Syndicate_Admin's avatar
Syndicate_Admin
Administrator
2 years ago
Solved

Replace Databases

Greetings Companions I have a dilemma, I have a dashboard which was made with a database that was made in a test way, however given the complexity of what was required of us to see if it was viab...
  • SamWiseOwl's avatar
    SamWiseOwl
    2 years ago

    Hi Syndicate_Admin 

     

    Go into the query editor (Transform Data) click on the Data Source Options.

     

    Click on the database and choose change source:

     

    Change the name of the database

    If everything is the same it should swap over 🙂 please make a back up of the pbix before changing

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi Syndicate_Admin ,

 

I think you can follow SamWiseOwl's reply to change data source. Note: backup your file is important.

 

According to your statement, I think you also can try to create and use report templates in Power BI Desktop.

 

With Power BI Desktop templates, you can streamline your work by creating a report template, based on an existing template, which you or other users in your organization can use as a starting point for a new report's layout, data model, and queries. Templates in Power BI Desktop help jump-start and standardize report creation.

 

For reference: Create and use report templates in Power BI Desktop - Power BI | Microsoft Learn

 

Best Regards,
Rico Zhou

 

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