How to refresh data in Power BI [STEP-BY-STEP GUIDE]

Milan Stanojevic
by Milan Stanojevic
Deputy Editor
0 Comments
Download PDF
Affiliate Disclosure

power bi how to refresh

The Refresh option is a basic function in Power BI. The tool has Refresh Now and Schedule Refresh as available options. You can use Refresh Now to perform a manual refresh in Power Bi Desktop. Also, you can schedule a refresh in a few easy steps.

Still, refreshing data in Power Bi is not so obvious at first sight, as one user said:

Ad

I have created some reports using Power BI desktop and Published those as a Web Page from Power BI service. My source is SharePoint. I want to schedule refresh of Power BI data from source SharePoint in every 2 hours. How to achieve this?

So, we know that the OP wants to refresh the Power Bi data from the SharePoint source once every two hours. Here’s how to do that.

Steps to refresh your data in Power BI

1. Configure credentials

First of all, you need to configure the credentials for data sources used in the Power Bi report.

  1. In the Power BI Report Server, right-click on the Power BI Reports.
  2. Select Manage.manage power bi report server
  3. Select the Data sources tab.
  4. Choose the type of authentication to use when connecting to that data source.
  5. Enter the appropriate credentials.

power bi credentials

2. Create a plan for Schedule Refresh

  1. Right-click on the Power BI Reports.
  2. Select Manage.
  3. Select the Scheduled refresh tab.
  4. Select New scheduled refresh plan.power bi schedule select steps
  5. Write a description and set a time for when you want your data model to be refreshed and then click on Create scheduled refresh plan.power bi create schedule

Find out more about Power BI Desktop from our comprehensive guide!


3. Use manual Refresh button from Home in Power BI Desktop

This is rather simple, but you can refresh your data one time only.

  1. Open Power BI Desktop.
  2. Load your file you want to refresh.
  3. Click on Refresh button from the Home ribbon.

power bi manual refresh

Conclusion

Refreshing your data in Power BI is a very useful feature, especially Schedule Refresh. Generally, people who work with this tool use dynamic sets of data and it is not physically possible to refresh them manually.

Did you find the methods useful? Let us know in the comments section below!

RELATED STORIES YOU NEED TO CHECK OUT:

Ad