Can't refresh DevOps report from Power BI on Service using Refresh Report button.

[ailsazheng]

I have a question about Power BI service. So I built a report in Power BI and the Refresh button on the top of the page does not refresh the data set. I can set the data set to refresh once every half hour tops, but there doesn’t seem to be a way for the refresh button to work on its own. It seems someone would have to go to the data set, refresh the data set first, and THEN hit this refresh button at the top of a report.

Do you know of a way to make the refresh work on service the way it does on Desktop? I read somewhere that you could create a workflow using Power Flow but I don't think we are going to use Flow.

[v-lid-msft]

Hi @ailsazheng ,

How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

Best regards,

[v-lid-msft]

Hi @ailsazheng ,

The refresh button in Desktop combine the get data and refresh the report page, but if use Import Mode in Power BI Service, the way to get latest data is to make a on-demand refresh ( or "Refresh Now") on the dataset, or configure scheduled refresh on this dataset.

If you want to get the latest data every time you refresh the report, the report should use DirectQuery Mode or Live Connect, but sorry for that, based on my research, we did not found a way to use DirectQuery to connect DevOps with the Azure DevOps (Beta) Connector or  OData Queries.

Best regards,

Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.