Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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
Solved! Go to 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 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]
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?
@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?
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!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.