Forum Discussion
ReFe0608
1 year agoNew Member
sync data source with semantic model
I am using Power BI (service) and was hoping that changes to the data source (MS list) would be recognized in the symantic model. Is it really necessary to recreate my report every time something cha...
- 1 year ago
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.
v-venuppu
1 year agoCommunity Support
Hi ReFe0608 ,
I hope this information is helpful. Please let me know if you have any further questions or if you'd like to discuss this further. If this answers your question, please accept it as a solution and give it a 'Kudos' so other community members with similar problems can find a solution faster.
Thank you.