Forum Discussion

ReFe0608's avatar
ReFe0608
New Member
1 year ago
Solved

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...
  • v-venuppu's avatar
    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.