importing data from excel

Question

Hi,I have data in my excel shown below, when I import it into Power BI, it is showing the row headers as values, which is wrong I tried using "Mark first row as header" option but then it is skipping the total for all columns.&nbsp;Power BI:&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;&nbsp;&nbsp;Power BI with row as header:&nbsp;&nbsp;Please help me to load the data&nbsp;Thanks in Advance

anonymous · Accepted Answer

Hi&nbsp;Anonymous&nbsp; &nbsp;you will have to select the three columns and unpivot the data to get the desired result...and then use matrix&nbsp;&nbsp;Please accept this as solution if this helped you

Forum Discussion

importing data from excel

1 Reply

Related content

Importing an overwritten excel file

Imported data from Excel Weeks out of Date

imported data not refreshshing in visuals

Power BI - Excel Data Import failing due to 32k cell limit

Import Excel to Fabric Warehouse error