Report is not refreshing at dataset refresh

[Rapaille]

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

[Rapaille · Accepted solution]

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.

[VijayP]

@Rapaille  Understood

in powerbi service , to Semantic Model - settings - 

by default the datasource setting show anonymous , refresh the credentials and then you will get the refresh automated

[VijayP]

@Rapaille 

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.

[Rapaille]

Hi @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.