Forum Discussion

IanCockcroft's avatar
IanCockcroft
Post Patron
11 months ago
Solved

online list structure not refreshing

Hi guys, i have a sharepoint list

i have added and populated a new column

when  refresh the connection sourse, it doesnt bring throgh the new column

if i change the source implementaton to 1, it does, but other fiels are wrong(assignees get an ID, not their name).

any idea how  can bring in he new column?

I did delete and reconnect. no luck.

maybe there s a cache i need to clear

any ideas?

thanks guys

Need Help
  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    11 months ago

    Hi IanCockcroft,


    Thanks for reaching out to the Microsoft Fabric Community Forum and sharing the details. You added a new column in your SharePoint list, but it’s not showing up when using the 2.0 connector. When you switch back to 1.0, you can see the column, but the Person fields break (showing IDs instead of names).

    This happens because Power BI caches the SharePoint list schema. A normal refresh only pulls the data, not the updated structure, so new columns may not appear right away. Here I provided some workarounds those might help to resolve your issue:

    Go to File > Options and Settings > Data Source Settings in Power BI, clear permissions for the SharePoint source, and reconnect with Implementation = 2.0. This forces Power BI to reload the list schema.

    In Power Query, try deleting and re-adding the navigation step to the list this refreshes the metadata and should bring in the new column. If the column still does not show, clear the Power BI cache (File > Options > Data Load > Clear Cache) and restart.

    As a workaround, if you must use 1.0, expand the Person/Group field in Power Query to pick the DisplayName instead of the raw ID.

    Refer this link: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list 

    Also, refer this community thread: https://community.fabric.microsoft.com/t5/Desktop/Sharepoint-list-not-refreshing-in-PowerBi/td-p/2626323 

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.

1 Reply

  • v-kpoloju-msft's avatar
    v-kpoloju-msft
    Community Support
    11 months ago

    Hi IanCockcroft,


    Thanks for reaching out to the Microsoft Fabric Community Forum and sharing the details. You added a new column in your SharePoint list, but it’s not showing up when using the 2.0 connector. When you switch back to 1.0, you can see the column, but the Person fields break (showing IDs instead of names).

    This happens because Power BI caches the SharePoint list schema. A normal refresh only pulls the data, not the updated structure, so new columns may not appear right away. Here I provided some workarounds those might help to resolve your issue:

    Go to File > Options and Settings > Data Source Settings in Power BI, clear permissions for the SharePoint source, and reconnect with Implementation = 2.0. This forces Power BI to reload the list schema.

    In Power Query, try deleting and re-adding the navigation step to the list this refreshes the metadata and should bring in the new column. If the column still does not show, clear the Power BI cache (File > Options > Data Load > Clear Cache) and restart.

    As a workaround, if you must use 1.0, expand the Person/Group field in Power Query to pick the DisplayName instead of the raw ID.

    Refer this link: https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-sharepoint-online-list 

    Also, refer this community thread: https://community.fabric.microsoft.com/t5/Desktop/Sharepoint-list-not-refreshing-in-PowerBi/td-p/2626323 

    Hope this clears it up. Let us know if you have any doubts regarding this. We will be happy to help.

    Thank you for using the Microsoft Fabric Community Forum.