Publish to web content not updating - sharepoint

[tonton]

I have a sharepoint list which contains a 'Due Date' column. I use this list as my dataset in my PowerBI Desktop

I created a column to count the DaysOverdue of the item using

=Duration.Days(Duration.From(DateTime.Date(DateTime.LocalNow())-[DueDate]))

Now I also created a column that if DaysOverdue > 0, "Overdue", "Not Overdue"

Initial values in the list shows that there are two(2) overdue items, but as the time pass by, today 09 September, another item reached the due date yesterday and the report should show three(3) overdue items but it's not showing the updated count.

I need to manually refresh and publish my power bi desktop for it to update in my publis

[v-shex-msft · Accepted solution]

Hi @tonton ,

If you use sharepoint connector to get data and publish to power bi service, you need to setup gateway to handle refresh operations of these datasources. (It seems like sharepoint connector is recognized as on premise data source instead of online datasource)

You can consider to use sharepoint rest api and web connector to get data. it will be recognized as online datasource and not require gateway to refresh.

Regards,

Xiaoxin Sheng