Forum Discussion

arenol's avatar
arenol
New Member
8 years ago

Sharepoint list columns do not update

Hi   I have got a connection to a sharepoint list and gets all the new data in the former columns in but the new columns does not show. What do i do wrong while updating?   Thanks
Phil_Gi's avatar
Phil_Gi
Regular Visitor
3 years ago

Hi all, arenol , Anonymous , v-huizhn-msft ,

 

It looks like this issue still exists.

 

When I update the name of an existing column in my SharePoint Online List or add a new column to the list, the changes are not reflected in the Dataset. Moreover, the refresh fails after making changes to the source.

 

I tried changing the lineage-setup and put a Dataflow in front of the dataset, hoping to get more controle of the names of the columns in the fields. It looked like, where it is not possible to make any changes to column names or format in Datasets (once published to the Power BI Service). It IS still possible to make changes to columns in the Dataflow in the Power BI Service.

But, unfortunately, the refresh of the new dataset, the one connecting to the Dataflow, fails as well after having made some name-changes to the SharePoint List ( "Data source error The 'oldcolumnname' column does not exist in the rowset.").

 

Old lineage:

 

New lineage:

 

I found this article on the learn.microsoft.com-website:

https://learn.microsoft.com/en-us/power-platform-release-plan/2022wave2/power-bi/dataset-authoring-power-bi-service

Maybe this functionality could help solve this issue? Either way, it looks like it hasn't been released yet ..

 

Since we're still kind of building this reporting here at the company, the column names in the SharePoint list change on a regular basis and new columns - that we want to use in our reports - are being added. Anyone has any suggestion on how to manage this?

 

Thanks in advance,

Regards,

Phil