Forum Discussion
Semantic Model not refreshing with the current data
There were no issues reported in the gateway log and database log .
Cleared the cache , restarted the database service , PBI gateway.
Tried the report in older version of PBI desktop.
Still the issue did not resolve.Did a copy of the data in that table .
Truncated the table .
Reloaded the table's data.
Restarted the PBI desktop and Gateway.
Now , the issue is resolved.We don't know what was the cause of the issue though.
Hi zahirmohideen ,
Thank you for reaching out to the Microsoft Community Forum.
Hi maruthisp , Thank you for posting response in community.
Hi zahirmohideen , In addition to maruthisp , i am adding some more workarounds to fix the issue.
Please check below things to fix the issue.
1. If the MariaDB table schema changed (renamed columns), Power BI Service does not automatically sync schema changes across chained semantic models.
Solution: Open the report in Power BI Desktop. Refresh it, re-evaluate schema references. Re-publish the report to the Service.
2. Sometimes, the report visuals cache old data
Solution: Clear browser cache or try in incognito mode.
3. Use Excel or DAX Studio to connect to the semantic model and verify if the new data is present.
Note: This helps isolate whether the issue is with the model or the report visuals.
4. Test with a New Report: Create a new power bi report, connect to the same MariaDB table using import mode. see if it pulls fresh data, this will rule out whether the issue is with the data source or the report model.
Please refer below Microsoft article
Troubleshoot refresh scenarios - Power BI | Microsoft Learn
If this information is helpful, please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
Hi zahirmohideen ,
We haven’t heard from you on the last response and was just checking back to see if you have a resolution yet.do click Accept Answer and Yes for was this answer helpful. And, if you have any further query do let us know.
Thank you.
There were no issues reported in the gateway log and database log .
Cleared the cache , restarted the database service , PBI gateway.
Tried the report in older version of PBI desktop.
Still the issue did not resolve.Did a copy of the data in that table .
Truncated the table .
Reloaded the table's data.
Restarted the PBI desktop and Gateway.
Now , the issue is resolved.We don't know what was the cause of the issue though.
Hi zahirmohideen ,
If the issue is resolved , please “Accept it as a solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.