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

Microsoft for Business » Power BI

Reading time icon 3 min. read

Calendar icon Updated on

by Milan Stanojevic 

updated on

Share this article

Readers help support Windows Report. We may get a commission if you buy through our links. Tooltip Icon

Read our disclosure page to find out how can you help Windows Report sustain the editorial team. Read more

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:

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.

These steps can be useful, but if scheduled refresh on Power BI is greyed out, we have a guide that can help you with that.

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

RELATED STORIES YOU NEED TO CHECK OUT:

Milan Stanojevic

Milan Stanojevic Shield

Windows Toubleshooting Expert

Milan has been enthusiastic about technology ever since his childhood days, and this led him to take interest in all PC-related technologies. He's a PC enthusiast and he spends most of his time learning about computers and technology. Before joining WindowsReport, he worked as a front-end web developer. Now, he's one of the Troubleshooting experts in our worldwide team, specializing in Windows errors & software issues.

User forum

0 messages