From the course: Power BI Data Methods (2019)

Unlock the full course today

Join today to access over 22,600 courses taught by industry experts or purchase this course individually.

Refreshing data

Refreshing data

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Refreshing data

- [Instructor] While Power BI allows us to easily refresh data and update connection options, we also need to exercise caution to avoid running into issues or errors. The query automatically adds new rows and columns to an existing dataset when we refresh it. However, if we rename, delete or change positions with the columns and the data source, this will err out the refreshing process. We refresh our CDC Flu Data Power BI Desktop file manually by hitting the refresh button at the top. We see it updates both of the connections. Refreshing the data also updates the entire query for the ETL process, which includes any transformation steps that also got loaded. You can think of Power BI Desktop as a design application, while Power BI Cloud Services are more for the enterprise level and working across organizations. Here's an example of a Power BI services account that we can load our Power BI Desktop file to. This is just a demo…

Contents