Get only one new column for an existing table (imported from SharePoint) in power bi

[Anonymous]

Hi everyone,

I added one column into an already exisiting SharePoint list.

This SharePoint List is linked to Power bi for further analysis.

However, it seems that power bi can't see whether or not there is a new column added in the SharePoint list.

Is there a way to get this new column (filled with data) without having to replace the entire table in power bi ?

I would like to avoid importing a "new table" and edit again the visuals.

Thank you in advance

Kind regards

[Greg_Deckler]

@Anonymous Does your Advanced Editor source line look like this?

Source = SharePoint.Tables("https://site.sharepoint.com", [Implementation=null, ApiVersion=15]),
#"{guid}" = Source{[Id="{guid}"]}[Items]

[Anonymous]

Hi @Greg_Deckler ,

Thank you for replying.

No, it looks like the following:

= SharePoint.Tables("https://site.sharepoint.com/sites/nameOfSite", [Implementation=null, ApiVersion=15])

#"{guid}" = Source{[Id="{guid}"]}[Items]

What is the impact of such a difference?

[Greg_Deckler · Accepted solution]

@Anonymous No, that looks fine. I'm not sure why the new column wouldn't be coming in. There isn't a parameter like for CSV files that specifies the number of columns. If you click on the Source step in your Applied Steps and refresh preview, does the column appear?

What happens if you create a new query and point it to the same list, does the column show up?

[Anonymous]

Hi @Greg_Deckler,

Thanks for the idea.

I downloaded again the PBIX-file of my report, looked for the table, right-clicked and selected "refresh data". The column finally appeared.

I thought this should happened automatically once the dataset get refreshed but apprently not.

Thanks again for your support!