Forum Discussion

NTIBOILERS's avatar
NTIBOILERS
Regular Visitor
7 years ago

Duplicate report - Same data source - different table

If i have a data source with 2 seperate tables (Table1 and Table2).

Both tables have the exact same column names but different values. 

 

I have created a report using my data from Table1.....

I want to duplicate the report but now pull the data from Table2 instead.  

Is there an easy way to achieve this ? 

 

Thanks in advance!!

5 Replies

    • NTIBOILERS's avatar
      NTIBOILERS
      Regular Visitor
      7 years ago

      The souce is the same. The table within the source is changing. 

      • jthomson's avatar
        jthomson
        Solution Sage
        7 years ago

        I've just tried doing this - I'm guessing you've got them formatted as tables, in the query editor go to the Navigation step, and then change the name of the table from the old one to the new one

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    HI NTIBOILERS,

     

    You can save your original report as a template then you can use it to create sample visualization with different data source.

    Deep Dive into Query Parameters and Power BI Templates

    After setup a new datasource and generate correspond report, use 'save as' to save current file back to pbix file.

     

    Regards,

    Xiaoxin Sheng