October Sale - 20% of all courses - Book Today

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 23577 Reviews
Excellent training course really filled in the gaps for me as a SharePoint administrator -SharePoint Site Owner Brisbane
Kristy - SharePoint Site Owner, .
Great course with very useful content. But also made me realise that Sharepoint is a massive tool with endless capabilities. -SharePoint Site Owner Brisbane
Richard - SharePoint Site Owner, .
Very good -Office365 Beginner Brisbane
Liem - Office365 Beginner, .
Great training - really good pace and so clear - enjoyed this training very much and learnt more than I knew before Thanks -Excel Customised Remote Online
Tricia - Excel Customised, .
Fantastic -Excel Customised Remote Online
Angie - Excel Customised, .
Learnt a lot thank you -Excel Customised Remote Online
Ann - Excel Customised, .
Amazing Trainer very patient and took the time to go through things thoroughly. Thank you Jason -Excel Customised Remote Online
Carly - Excel Customised, .
Very well structured course, easy to understand and follow. Highly recommended !! -Power BI Intermediate Sydney
Josep - Power BI Intermediate, .
Insightful Training. Trainer extremely helpful and took time to sort out any issues on the program. Trainer offered extra tuition if required. Trainer clear and concise in explanation. -Power BI Intermediate Sydney
Aishling - Power BI Intermediate, .
It is a good course. I learned a lot from this. Thank you -Power BI Intermediate Sydney
Eric - Power BI Intermediate, .
Very engaging, enjoyed and learned a lot. -Power BI Intermediate Sydney
Roman - Power BI Intermediate, .
Jagg teach method made the day very informative and interesting. Would have liked some notes to take away on tips and tricks. -Power BI Beginner Adelaide
Allison - Power BI Beginner, .
Very, very good. Extremely knowledgeable, very good communication, loved the hand gestures. -Power BI Beginner Adelaide
Rhett - Power BI Beginner, .
Extremely insightful and very helpful. For someone who has not had a lot of exposure to Power BI, I now feel quite confident with the basics of the program. -Power BI Beginner Adelaide
Ryan - Power BI Beginner, .
Jagg was excellent and have a good sense of humer!!. Learned a lot. Thanks Jagg. -Power BI Beginner Adelaide
Hikkaduwa - Power BI Beginner, .
Great introduction to Power BI, easy to follow along with, lots of good insight and well presented. Instruction was clear and good examples provided. -Power BI Beginner Adelaide
Linda - Power BI Beginner, .
great overview of the building of beginner power BI reports and dashboards. cant wait to build more reports -Power BI Beginner Adelaide
Louise - Power BI Beginner, .
That was very informative and well paced. Thank you -Power BI Beginner Adelaide
Hina - Power BI Beginner, .
Excellent course, Jagg was very informative and clear - thank you -Power BI Beginner Adelaide
Emma - Power BI Beginner, .
very knowledgeable -Office365 Beginner Brisbane
David - Office365 Beginner, .

Trusted by Business

south east asia microsoft training courses nexacu

Follow us