Microsoft Power BI Complete Reference

Use First Row as Headers

Organizing column names or headers is often an important first task when organizing your dataset. Providing relevant column names makes many of the downstream processes, such as building reports, much easier. Often, column headers are automatically imported from your data source, but sometimes you may be working with a more unique data source that makes it difficult for Power BI to capture the column header information. This walkthrough will show how to deal with such a scenario:

1. Launch the Power BI Desktop, and click Get Data under the Home ribbon.
2. Choose Excel, then navigate and select Open on the Failed Bank List.xlsx file that is available in the book source files.
3. In the Navigator window, select the table called ...