Forum Discussion
sync data source with semantic model
Hi ReFe0608 ,
Thank you for reaching out to Microsoft Fabric Community.
- In Power BI, when you connect to a data source like Microsoft Lists, any changes made to the source (such as adding new columns, removing columns, or changing column names) won't automatically reflect in the semantic model (i.e., the data model in Power BI) unless you refresh the model or adjust it manually.
- However, you don't need to recreate your entire report from scratch every time a change happens in the data source. There are ways to update the Power BI report without rebuilding it entirely.
Here’s some steps how you can handle it:
- Refresh the dataset to get the new or updated data.
- Check the Power BI model to ensure new columns are recognized.
- If needed, modify the Power Query transformations or model to accommodate the new structure.
- Adjust or create new visuals to include the new data without rebuilding everything.
If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it!
Regards,
Rama u.
Hi ReFe0608 ,
No, you don’t need to recreate your report every time the MS List (data source) changes. However, Power BI doesn’t automatically pick up schema changes (like new or renamed columns) in the semantic model. To sync changes, open the report in Power BI Desktop, go to Transform Data, then hit Refresh Preview in Power Query Editor.
This pulls in the updated schema. After that, apply changes, republish the report, and the semantic model in the Power BI Service will update accordingly. Unfortunately, there's no direct way to sync schema changes in the Service alone—it has to be done via Desktop.