Forum Discussion
Replace data source with new data source and different structure
Hi All, We have a power bi report built on three different spread sheets in an Excel. Recently they have provided a new Excel with all the fields combined from the 3 different tabs into a single...
Anonymous Really need more information but in theory you could simply point to the new spreadsheet in each of the queries and remove the columns that are not in each of the current queries.
Anonymous Really need more information but in theory you could simply point to the new spreadsheet in each of the queries and remove the columns that are not in each of the current queries.
Thank you Greg for pointing me in the right direction your mentoined approach worked.
but when I am changing the power query with required columns still all the columns are coming into the data model. I had to remove them from choose columns option.
Is this by design?