Forum Discussion
Power BI report connected to MS forms - Transform data with an empty excel sheet
Hi Anonymous ,
I suggest that you create a parameter for the MSForms path this way you can change it to the new form when you have answers and everything should work properly if all the settings (names, columns, etc.) are the same.
https://learn.microsoft.com/en-us/power-query/power-query-query-parameters
Super UserHi Anonymous ,
I suggest that you create a parameter for the MSForms path this way you can change it to the new form when you have answers and everything should work properly if all the settings (names, columns, etc.) are the same.
https://learn.microsoft.com/en-us/power-query/power-query-query-parameters
Thank you MFelix ! I appriciate the quick answer. The origianal two data sheets have exactly the same names/columns etc, but I have made changes to the data in the sample sheet in "transform data" so now there are a lot of new custom columns that I have added and moved around (which is what I would like to do to the new data as well). Does it still work?
- MFelix
Hi Anonymous ,
If the base columns are the same you should not have any problems with the connection to the new source, it will apply the steps in the same way and return the correct result.
Thing to be aware are the number of columns, data types (sometimes they can impact) and column names (M langauge is case sensitive) on the source data step everything else should not raise problemns becuaase are transformations on top of the data source.
Thank you very much!