'%3e%3cpath%20d='M8%200C12.4183%200%2016%203.58172%2016%208C16%2012.4183%2012.4183%2016%208%2016C3.58172%2016%200%2012.4183%200%208C0%203.58172%203.58172%200%208%200ZM11.6162%204.38379C11.2257%203.99337%2010.5927%203.99338%2010.2021%204.38379L8%206.58594L5.79785%204.38379C5.40732%203.99334%204.77429%203.99329%204.38379%204.38379C3.99331%204.77429%203.99335%205.40733%204.38379%205.79785L6.58594%208L4.38379%2010.2021C3.99348%2010.5927%203.99341%2011.2257%204.38379%2011.6162C4.77426%2012.0066%205.40734%2012.0065%205.79785%2011.6162L8%209.41406L10.2021%2011.6162C10.5927%2012.0066%2011.2257%2012.0067%2011.6162%2011.6162C12.0067%2011.2257%2012.0066%2010.5927%2011.6162%2010.2021L9.41406%208L11.6162%205.79785C12.0066%205.40735%2012.0066%204.77429%2011.6162%204.38379Z'%20fill='%23080E17'%20fill-opacity='0.46'/%3e%3c/g%3e%3cdefs%3e%3cclipPath%20id='clip0_3761_713'%3e%3crect%20width='16'%20height='16'%20fill='white'/%3e%3c/clipPath%3e%3c/defs%3e%3c/svg%3e)
How to Update a Power BI Semantic Model from SharePoint When Adding Columns
Question details
Users need to update their Power BI semantic model to include newly added columns from a connected SharePoint list.
- Product
- Power BI / SharePoint
- Device & OS
- not provided
- Scenario
- Exporting a SharePoint list to Power BI and subsequently adding new columns to the SharePoint list.
- Observed behavior
- Refreshing the exported list updates existing data but fails to pull in newly created columns, as the connection schema is not automatically updated.
Verify that your existing SharePoint list data is refreshing properly in Power BI before attempting to troubleshoot missing newly added columns.
Understand the Limitation and Consult the Microsoft Fabric Community
Currently, there is no direct built-in way for the exported list connection to automatically detect schema changes like new columns.
When you export a SharePoint list to Power BI, the connection schema is generated based on the columns present at that exact moment. Merely clicking 'Refresh' will update the data within the existing columns but will not modify the underlying connection schema to include newly created columns.
Confirm that clicking 'Refresh' in Power BI successfully updates the existing rows and data for the original columns.
Navigate to the Power BI forums within the Microsoft Fabric Community online.
Search for 'SharePoint Online to Power BI schema update' to find community-supported workarounds, such as using Power Query to manually adjust the source step or API calls.
If no existing workaround fits your needs, post a new question detailing your SharePoint list structure and Power BI setup.
Manually Update the Power Query Source (Advanced Workaround)
Modify the M code in Power Query Editor to force Power BI to fetch the updated SharePoint list schema.
Need a simpler way to manage lists and analyze data?
While Power BI handles complex semantic models, sometimes you just need a straightforward, robust spreadsheet tool to manage data lists and generate charts. WPS Office is a highly compatible, free, and lightweight alternative to Microsoft Office that makes data analysis intuitive and hassle-free.
Frequently Asked Questions
Why doesn't my Power BI dataset show new SharePoint columns?
When a SharePoint list is initially exported to Power BI, the connection schema is locked to the columns available at that specific time. Standard data refreshes only update the content of those original columns, not the schema itself.
Can I fix the missing SharePoint columns without starting over?
Yes, advanced users can often resolve this by opening the Power Query Editor in Power BI Desktop and modifying the Source step to force a schema refresh, although official support recommends consulting the Microsoft Fabric Community for the latest supported methods.
Where can I find official help for Power BI schema limitations?
The best place to find official workarounds and advice from Microsoft experts regarding this specific SharePoint-to-Power BI limitation is the Power BI forums in the Microsoft Fabric Community.
