Chnage data source even if column sequence is not same

[Anonymous]

Problem : I want to chnage data source but my column sequence is not same.

Solution : To verify if we can do  this first we will add new data source.

For this we will be using exxcel source as shown below.

Go to  Get data in Power BI desktop and load this data using excel source.

Now we will go to  Same excel file again and change sequence of the columns also, remove last 3 rows.

After changing the column sequence we will save it as new file.

Now, we will go to Data transformation >> data source setting >> chnage data source and select new excel file path.

Click on Ok and then click close and cclick on apply chnages.

 

Now,  you can see see in the fields pain columns are  same but data has been chnaged according to new Excel file.

Final Output:

 NOTE : We can chnage column sequence but all column header names needs to be same in order to chnage data source.

Hope this will be helpful!

Thanks and Regrds,

Ashwin Kulkarni, BI Consultant
Nice Software Solutions,
Address: 21, IT Park, Wing – A, Ground Floor,
Gayatri Nagar, NAGPUR - 440022 (India)
Mobile: 0712 664 4575

Linked in group : https://www.linkedin.com/groups/10483395/