From the course: Power BI Essential Training
Unlock the full course today
Join today to access over 24,800 courses taught by industry experts.
Transform data - Power BI Tutorial
From the course: Power BI Essential Training
Transform data
- [Instructor] This is the file that we worked on in the last movie. If you're just joining us, you can open ReducedStates.pbix from the exercise file and you'll be right where I am. Sometimes when you open a PBIX file, you might see an error message when you open the query editor that says that the data source could not be found. That doesn't mean the PBIX file can't be found. What it means is that the file that the PBIX file is based on has been moved or its name has been changed. It can no longer be found. And if that's the case, what you need to do is go to your data source settings, look for data sources in the current file. This is the source that it thinks it's looking for. And you can change the source and browse to find the correct file, select it and everything should be fine again. I'd like to show you some of the transform tools that are available in Power BI Desktop. Once we enter the query editor, transform data, transform data, we have frequently used transform tools…
Practice while you learn with exercise files
Download the files the instructor uses to teach the course. Follow along and learn by watching, listening and practicing.
Contents
-
-
-
-
-
-
-
-
-
-
(Locked)
Install and launch Power BI Desktop5m 5s
-
(Locked)
Get data3m 16s
-
(Locked)
Use views2m 50s
-
(Locked)
Reduce data4m 52s
-
(Locked)
Transform data6m 8s
-
(Locked)
Tweak your dataset for Q&A5m 32s
-
(Locked)
Relate tables4m 28s
-
(Locked)
Get Power BI Desktop data with the Power BI service2m 54s
-
(Locked)
Export a report from the Power BI service to Desktop3m 46s
-
(Locked)
-