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.

Accessing native query in cleaning

Accessing native query in cleaning

From the course: Power BI Data Methods (2019)

Start my 1-month free trial

Accessing native query in cleaning

“

- [Narrator] We earlier setup a connection to a SQL server for the CDC flu data to test out how database connections work in Power BI. We discussed how Power BI gives us the capability to use Query Folding to optimize performance for database connections. Let's rename this query SQL Server Connection. We Right Click and Select Rename and hit Enter to save it. Next, let's see if we move a column, what the impact on the Query Folding will be. We already know, from Right Clicking on the Navigation Step that we can view the Native Query, and we see that it looks like a SQL query. Now, let's make more adjustments to this data table, and see what the impact on Query Folding is. Click on Total Patients. Click on this column. Right Click and select Moved To The Beginning. Whether or not we want to leave it here is not particularly relevant, but let's see if we can still view the Native Query after performing this…

Contents