Online SharePoint List Data as DataSet is not getting refreshed in Power BI Visuals

[Anonymous]

Hi Team,

I am struggling to get one of my DataSet refreshed from the global refresh option at top ribbon from Power BI Desktop. All other datasets are getting refreshed but only this data is not refreshed. When I manually right click on DataSet ->click on "Refresh Data"option specific to that datasource then the new data is reflected in the Power BI Visuals. Can someone please let me know what is the issue. I have written M code to fetch the data from the SharePoint Rest Api.

Showing Correct Time When I clicked on Refresh Button from global option:

Time not showing correctly on this:

I am clueless what is happenng here. If some one can help me would be highly appreciated. Thanks in advance.

[Anonymous]

Hi @Anonymous, 

I've tried but I'm sorry I couldn't reproduce your problem.

You can perform a one-time, manual refresh in Power BI Desktop by selecting Refresh on the Home ribbon. When you select Refresh here, the data in the file’s model is refreshed with updated data from the original data source. This kind of refresh, entirely from within the Power BI Desktop application itself.

Are the datasets in this report all from the same data source? Have you checked in the query editor if it is set to "not included in report refreshes"?

If it is convenient, please provide more details, I can help you better to solve the problem.

Best Regards,

Caitlyn Yan

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.