Column names are not mapped correctly with the sharepoint list

[dinesharivalaga]

Hi Experts,

I am duplicating sharepoint list to do the testing activities in the Power BI dashboard to avoid the mess on the existing sharepoint list and user.

Once duplicated , i am trying to map the source into the dashboard but after navigation steps there is no proper column names are aligned . "Test Delivery Updates" is the duplicated one. All the columns are available as per the original list (Delivery Updates)

I can see the source id everything is correctly mapped but the column names are not as expected from the list , it is showing field1,field2 ... etc as below in the power query :

I have tried to copy the full advanced editor query from the existing dashboard and pasting in the new DB with replacing source ID but still not working and getting error message :

Please help to solve this asap ..

Thanks

DK

[christinepayton · Accepted solution]

This looks like you used the feature that creates a list from another list or Excel file. What this does is it creates the columns with generic field1/field2/etc names, and then renames them to your desired fields. The 1.0 SharePoint list connector will show you those back-end names, it's expected behavior. The 2.0 connector might show the updated names - I would try reconnecting to the list and selecting the 2.0 connector in the initial connection (it's called "implementation" there). 

[dinesharivalaga]

@christinepayton  Yes christine , I have reworked on the new list with 2.0 connector and everything captured well and then did further steps in power query . 

Thanks a lot for your solution 🙂

[Greg_Deckler]

@dinesharivalaga How did you duplicate the SharePoint list exactly?

[dinesharivalaga]

@Greg_Deckler  

Step 1:

Step 2:

then selected the existing list which you want to replicate and created with the new name.
Post that i have tried to map the new list into test dashboard.

Thanks
DK