Forum Discussion

Rapaille's avatar
Rapaille
Icon for Helper I rankHelper I
2 years ago
Solved

Report 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 th...
Need Help
  • Rapaille's avatar
    Rapaille
    2 years ago

    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's avatar
VijayP
Icon for Community Champion rankCommunity Champion
2 years ago

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's avatar
Rapaille
Icon for Helper I rankHelper I
2 years ago

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.