Forum Discussion
Semantic Model not properly refreshing
I have an existing table in my Lakehouse, and the table is also in the default semantic model. In Excel, I created a chart using Data > Data from Power BI, and selecting my table from the Lakehouse.
After that, I inserted more rows of data into the Lakehouse table via a Fabric notebook. When I went to the Lakehouse, I could see that the table has been updated. I refreshed the Power BI connection in Excel, but my chart did not update. I then tested the semantic model by creating a report within my Fabric workspace from it, and I can see that the new rows are missing from the report.
In the past, I've ran a dataflow replacing the entire table (not inserting) with new data and the semantic model refreshed properly - I could see the changes reflected in Excel.
How can I refresh the semantic model to include the newly added rows of data? I would like to not have to manually delete the table from the model and adding it back in (although this works), since this I'm trying to automate processes. If I do have to delete the table from the model and add it back in, is there a way I can do this through code? - so I can add the code to my notebook which will be run on a schedule
To future visitors, the fix was to either
- go to the semantic model (Lakehouse > SQL Analytics Endpoint > Default semantic model settings > turn on Sync the default model. The model will update when you add more rows of data to your tables
- or create a new custom semantic model with your desired tables. It will auto update
7 Replies
To future visitors, the fix was to either
- go to the semantic model (Lakehouse > SQL Analytics Endpoint > Default semantic model settings > turn on Sync the default model. The model will update when you add more rows of data to your tables
- or create a new custom semantic model with your desired tables. It will auto update
We also experience intermittent refresh issues when connecting to the semantic model via Excel.
This happens in both, Excel in the browser and Excel client which are all up to date.
Is this a know Excel limitation because most analysts still use Excel and pivot tables?
Hi alee023 ,
Adding new columns involves changes to the schema, which cannot be refreshed in the service. More details can be found in the documentation: Data refresh in Power BI - Power BI | Microsoft Learn.
Also, I found a similar case, maybe you can refer to it. Solved: Re: How do I automate PowerBI Semantic model schem... - Microsoft Fabric Community
If your Current Period does not refer to this, please clarify in a follow-up reply.
Best Regards,
Clara Gong
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
To clarify, I'm not adding additional columns or changing the schema of the table. I'm adding more rows of data to the table.
I have the exact same issue with zero changes .. IN facy the EXACT Power BI DataWarehouse, Power BI PBIX file with one report works perfectly on another account in Powert BI just fine. The ONLY different is the name of the data source whicih ois the
"blahblablahblahblah.datamart.fabric.microsoft.com" Connection string. That's it and that's all ??
Any resolution on this by now?
Thanx
