Forum Discussion
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 excel to another Appenede Table(source for this appaended table is 2 excel sheets).
Is it possible?
Regards,
RDS
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.
9 Replies
Are the old table and the new table identical in structure, same field names, data types and everything ?
If so you can use "Duplicate" to make an exact copy of the old table, and then change its data source property to the new table. This post gives good instructions https://radacad.com/reference-vs-duplicate-in-power-bi-power-query-back-to-basics
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
Hello rds_2019
Your model only cares about what comes out of PowerQuery, not all the steps that PowerQuery goes through to get there. What you want to do is create a table using your new data source, the append query, and make sure it's output has the EXACT same columns as your old table. Sames names exatly ("column" is not the same as "Column") and same data types.
Once you have that you can open your new query in advanced editor and copy out all the code. Then open your old query in advanced editor and replace all the code with the code from your new source.
Hi jdbuchanan71 ,
Thanks for replying, how can add Appended Table as a source to the New Table coz Table created by Appending 2 excels doesnt show up in the browser to be added as a source.
RDS
You would pull in each file as it's own query then combine them in an append query and make the output of the combined append the source you send into the model.
