Forum Discussion
Helper IReport is not refreshing at dataset refresh
Hello,
I have a dataset with a report. The dateset refreshes 3 times per day, but the report is not updated after the dataset refresh.
What do I have to do to refresh the report along with the dataset?
Kind regards,
Hans
SharePoint only updates the calculated columns when the item is updated.
Now I use Power Automate to update a column with the current date + time and refresh the Power BI dataset after.
That's what works for me.
4 Replies
- VijayP
Community Champion
Ensure that the report is correctly linked to the dataset. It seems the report is not updating automatically because it might be connected to the wrong data source. Verify that the report is connected to the correct dataset that is being updated, and not to an outdated or incorrect data source.
RapailleHi VijayP,
I checked and the report is connected to the correct dataset.
The dataset is connected to a SharePoint list and I have added a calculated column in the table view. When I look in the dataset in my workspace, it looks the calculated column does not update during the refresh.
- Rapaille
SharePoint only updates the calculated columns when the item is updated.
Now I use Power Automate to update a column with the current date + time and refresh the Power BI dataset after.
That's what works for me.
