From the course: Power BI Essential Training

Unlock the full course today

Join today to access over 23,200 courses taught by industry experts.

Transform data

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…

Contents