Troubleshooting a report refresh

[cbanbury]

I'm using a Datamart to store my data (which is being pulled from a web API on a scheduled refresh every night). I can query the data in the datamart and see that it has been updated. However, when my users try to refresh the report which is using this data using the refresh button on the service: it doesn't work.  The only way I can get the data to refresh, is to open the report in PowerBI Desktop, clicking the refresh button here and then republishing.

I must be missing something and I've tried to find the answer online and failed.  Can anyone give any pointers on how to allow users to pull through refreshed Datamart data into a PowerBI report on the service?

[Anonymous]

Hi @cbanbury ,

It sounds like you may need to adjust the refresh settings for your report in the Power BI service. By default, reports are set to refresh on a schedule, but you may need to adjust the settings to allow for manual refreshes as well.

To do this, go to the "Settings" menu for your report in the Power BI service, and then select "Options". From there, you can adjust the "Data source credentials" and "Scheduled refresh" settings to ensure that your report is able to access and refresh the data in your Datamart.

You may also want to check that your users have the appropriate permissions to access and refresh the data in the report. If they don't, they may not be able to refresh the report using the refresh button in the service.

More details: Get started with datamarts (preview) - Power BI | Microsoft Learn

Allow End Users To Refresh Dataset Whenever They Want (On Demand) (c-sharpcorner.com)

Best Regards
Community Support Team _ Rongtie

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

[lbendlin]

You don't refresh reports, you refresh datasets.  

Are you connecting to the datamart via Direct Query or import mode? If import mode - have you set up a scheduled refresh for the dataset in the workspace?