Forum Discussion
Replacing a datasource via Advanced Editor | Can I add another column?
Hi all,
I've been using 1 SQL view to pull data and create BI reports for all of our customers. The View is identical and pulls all the same type of data. In the DB, I found another column that would be useful to pull in.
I've created a bunch of measures and calculated columns in my template (sample data) - usually, what I would do is I go into the client's enviornment, connect to the SQL view, then replace the datasource via Advcanced editor from the sample data in there, to the new real client data. Then the measures and calculated columns all poppulate perfectly.. because all of the names of tables and everything is the same.
If I add in an extra column, will I still be able to do this kind of plug and play? Or will it mess everything up? I do no transformations in Power Query - only in DAX for calculated columns and measures.
1 Reply
- jdbuchanan71
Super User
As long as the new column exists in the view on the client database and it does not conflict with the name of any calculated column you have added it should work fine.