Can we refresh Data source after publishing the report?

[Anonymous]

Dear All,

Hope you doing good!

I have report and publish it on power bi service i want it to refresh data source after publishing it can i achieve this? if yes please help me how can i do this?

[v-alq-msft]

Hi, @Anonymous 

There are three main data access scenarios:

• A dataset uses data sources that reside on-premises
• A dataset uses data sources in the cloud
• A dataset uses data from both, on-premises and cloud sources

If your dataset uses a data source that Power BI can't access over a direct network connection, you must configure a gateway connection for this dataset before you can enable a refresh schedule or perform an on-demand data refresh.

You may go to 'Manage Gateway' in Power BI Serivice and add data source definition to the corresponding gateway.  Also make sure your gateway admin adds your user account to the list of users with permissions to use the data source. Then The dataset settings page lets you select an enterprise gateway with a matching data source that you have permission to use. Make sure you map the correct data source definition to your data source.

Finally you can configure-scheduled-refresh or click 'Refresh now' for the corresponding dataset to refresh data.

Best Regards

Allan

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

[amitchandak]

@Anonymous ,

https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-scheduled-refresh

https://docs.microsoft.com/en-us/power-bi/report-server/configure-scheduled-refresh

https://medium.com/@nimaiahluwalia1998/schedule-refresh-power-bi-dataset-with-power-automate-b0af60f611f1

[az38]

@Anonymous 

yes, you can refresh dataset manually or by schedule. see more here https://docs.microsoft.com/en-us/power-bi/connect-data/refresh-data#refresh-and-dynamic-data-sources

[Anonymous]

I didn't find refresh data option in power bi service.