Semantic Model not refreshing with the current data

[zahirmohideen]

I have a PBI report connected to  MariaDB Database in the import mode.

This report connects to a table where the data is loaded monthly

Up till now , the semantic model and report worked fine.

Now , after the monthly update of the table , the data is getting refreshed both in PBI Service and PBI desktop. 

No issues reported in PBI desktop / PBI service. No errors in the gateway  either. 

I recently updated PBI desktop , cleared the cache . It does not refresh . It still shows the stale data.

Where else , I look for potential issue?

Thanks in Advance.

[v-dineshya]

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.

[v-dineshya]

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.

[zahirmohideen · Accepted solution]

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.

[v-dineshya]

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.

[maruthisp]

Hi zahirmohideen,

Please try the below steps and see if it can help you:
1. Can you confirm and double check that the MariaDB table actually contains the new data.

2. Check for any query foldings or filters - check in Transform data editor

3. Check relationships and may be new data matching keys doesn't match with other tables

4. Clear cache again

5. Go back to the previous Power BI version and check if the issue still exists.

6. Check Semantic model in Power I service for refresh hisroy and find out the lates refresh timestamp

7. Try using excel to analyze to see new data

If this reply helped solve your problem, please consider clicking "Accept as Solution" so others can benefit too. And if you found it useful, a quick "Kudos" is always appreciated, thanks! 

Best Regards, 

Maruthi 

LinkedIn - http://www.linkedin.com/in/maruthi-siva-prasad/ 

X            -  Maruthi Siva Prasad - (@MaruthiSP) / X