Forum Discussion

rds_2019's avatar
rds_2019
Helper I
6 years ago
Solved

Change Report's Data Source

Hi All, My Report is using Excel Table as a Data Source. After processing i have to create another Appended Table, which i would like to use as a data source How can i change current Data source ex...
Need Help
  • v-lid-msft's avatar
    v-lid-msft
    6 years ago

    Hi rds_2019 ,

     

    Based on your describle, We did some tested on it, your first solution should works fine, just change the query of table1 to the following in the Advanced Editor, But never forget to make backup of pbix file.

     

     

    Append__Table1

     

     

     

    After reference to the append table, all your visual and measure releated to old table will still exist.

     


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

rds_2019's avatar
rds_2019
Helper I
6 years ago

Hi,

I cant change the data source , coz the existing data source is from Excel Table  and the data source i want to replace to is Appeneded Table, both are in exactly same in number of columns and data type etc. Since for change in Data source its more related to actual Physical Table where as Table which are created in Power BI by appeneding 2 more more tables are not physical  so doesnt show up in the browsing window while changing the Data Source.

 

Regards,

RDS