The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
I have created an excel datamart and later in power bi desktop created a dynamic connection to create a report which I have published in power bi web.
In power bi web I have programmed automatic updates of the datamart every 30 minutes.
The published report is updated correctly, however, out of nowhere it stops working and is no longer updated. It doesn't give me any error, it just doesn't update.
I enter the datamart and find the updated data but the report no longer updates.
Any recommendation?
Hi @Anonymous ,
Try to delete the table from the datamart and add the table back in again .
Since datamarts are in preview, and the purpose of the preview phase is to catch such bugs.
refer:
Datamart is not refreshing because of changed data... - Microsoft Power BI Community
Best Regards
Lucien
I am experiencing the same issue. I changed the format of a column within a table in a Data Mart (from decimal to text)
I've tried closing and reopening the pbix, but the column format won't change. I've already have several measures written for the table and it will be a pain to bring in another instance of the table which shows the corrected format column. This is a bug for sure!
I reloaded the datamart and the report is updated again, but after a few hours it stops updating again. I enter the datamart and the data is up to date but it stops being passed to the report.