All courses available in-class or via remote login

Refresh visual

Data Refresh in Power BI

April 09, 2019

Power BI has fast become a leading Business Intelligence ecosystem

Power BI brings the art of data visualisation back under the control of data owners and business users.

You can easily connect to your data, perform cleansing and modelling, and develop meaningful visuals. However a challenging concept is that of refreshing the data.

So how do you keep your dashboards current?

The creation of more complex data models and reports usually begins with Power BI Desktop.

Each PBIX file contains the: - Report (which can have many pages/tabs) - Definition of the data model (tables, relationships, data types), and - Data itself.

Refreshing is performed manually via the Refresh button on the ribbon bar or when applying changes after a query is modified in (Power) Query Editor.

Power BI Data Refresh Button

When publishing to the Power BI Service, the Desktop will update the Workspace with the report and all of the data model. This includes the data as it was last refreshed in Desktop.

The data refresh concept is different in the Power BI Service. Data can be refreshed either manually or by configuring a refresh schedule.

PowerBI Setting up Data Refresh

How the data is refreshed depends on the data source. A limited number of data sources can be refreshed directly in the Power BI Service, without any additional help.

For the majority of data sources,  a bit of help is needed. This is achieved by using the Data Gateway application that can be downloaded from the Power BI Service website.

Data Gateway

The Data Gateway enables Power BI to connect with sources, that it cannot connect with directly. This is particularly important for on-premises and many cloud-based data sources.

The same Data Gateway is also used by Microsoft PowerApps, Flow and Azure Logic Apps. It can be run on a local PC (called Personal Mode) but is best installed in a server environment where is can be active 24 x 7.

PowerBI Data Sources

All data source configuration and Data Gateway settings are managed in the Power BI Service portal. Each gateway (you can run several) can have several administrators and each data source configured on the gateway can have many users.

Don't forget to update your credentials

When publishing from Power BI Desktop the data source settings are loaded into the Power BI Service although the credentials are not. The first step you should do after publishing is check and configure dataset credentials.

Data Refresh Credentials

These need to be entered in the dataset settings. The gateway does not need or store any credentials, so everything is managed in the Power BI Service.

Summing it Up!

Data Refresh in Power BI

 

Some other conveniences offered by Power BI.

Each of these come with their own benefits and limitations:

  • Data sources on OneDrive or SharePoint can be refreshed on an hourly basis.
  • DirectQuery, supported by several data source types, allows connection to the data source as and when needed rather than loading data into Power BI periodically.
  • Having a Premium license enables more frequent refreshes (up to 48 per day!) and even incremental refresh (as the usual behaviour is the entire dataset is refreshed - every table, every row).
  • Instead of manually publishing a PBIX to the Service you can save it to OneDrive or SharePoint.  Then use Get Data -> Files to load the report and dataset into Power BI. This makes use of the hourly refresh for any data model or report changes to the PBIX file!

For more articles like this follow us on LinkedIn or Facebook.

 

Further Reading

The following articles provide more detail and instructions on the data refresh process and using the Data Gateway. https://docs.microsoft.com/en-us/power-bi/refresh-data https://docs.microsoft.com/en-us/power-bi/service-gateway-onprem https://docs.microsoft.com/en-us/power-bi/refresh-scheduled-refresh

Contact Us

What is Remote Training?

Valued by Individuals

4.8/5
Over 23083 Reviews
The course provided a great base to continue my learning with Power BI. -Power BI Beginner Melbourne
Chris - Power BI Beginner, .
John was direct and concise with his delivery. As a Supervisor I am now more prepared to request reports of the types I require . Long day but excellent information and paced well. Thank you -Power BI Beginner Parramatta
Glenda - Power BI Beginner, .
Very interesting course. John was great but the course was a lot to take in one day, maybe it should be split into 2 sessions over 2 days. -Power BI Beginner Melbourne
kaan - Power BI Beginner, .
Very informative and easy to follow. Patient and communicated well Now have a better understanding of how to set up Power BI reports. -Power BI Beginner Melbourne
Melanie - Power BI Beginner, .
Steven has a great knowledge and great present skill for the day. the course was well designed. satisfied with everything. Thank you -Power BI Beginner Brisbane
Megan - Power BI Beginner, .
Hands on, enjoyable training. Thank you Steven -Power BI Beginner Brisbane
Catalina - Power BI Beginner, .
Good intro into the world of Power BI. Hope to be able to put it into practice straight away -Power BI Beginner Brisbane
Raelene - Power BI Beginner, .
Useful course and excellent trainer -Power BI Beginner Brisbane
Rajesh - Power BI Beginner, .
Course was well structured and paced. Steven was a knowledgeable instructor. -Power BI Beginner Brisbane
Brianna - Power BI Beginner, .
Really good fun and informative with Steven, as always. -Power BI Beginner Brisbane
James - Power BI Beginner, .
Thank you! See you again for intermediate and advanced -Excel Beginner Brisbane
JULIE - Excel Beginner, .
Jason was an awesome instructor that had my full attention for the duration of the course. I really enjoyed the hands on experience & being able to follow along with my own laptop. Thank you for an amazing course! -Excel Beginner Brisbane
Emma - Excel Beginner, .
Well delivered class! Definitely learnt a lot and had a laugh which was good. Thank you Jason, you're an excellent teacher. -Excel Beginner Brisbane
Layla - Excel Beginner, .
Very much enjoyed the course, easy to understand and follow, I feel like I have a better understanding of the program now so thank you Jason! -Excel Beginner Brisbane
Serena - Excel Beginner, .
Excellent course -Excel Beginner Brisbane
Nahan - Excel Beginner, .
AMAZING! So grateful I completed this. See you for intermediate and advanced soon :) -Excel Beginner Remote Online
JULIE - Excel Beginner, .
made sense of what i have been trying to achieve since moving into an office environment -Excel Beginner Brisbane
Joseph - Excel Beginner, .
Excellent trainer -Excel Beginner Brisbane
Peter - Excel Beginner, .
Really helpful - good teacher -Excel Beginner Brisbane
Martin - Excel Beginner, .
Great session with Jason as always -Excel Advanced Remote Online
Rebecca - Excel Advanced, .

Trusted by Business

Procured by Government

Map of Australia