Excel MANUAL table to Power BI

[Anonymous]

4 tables in 1

Hi all,

this data was manually done in excel. When I upload it to Power BI it doesnt seperate the data how it is. How can I import this sheet into Power BI and get it to look something similar? I tried building relationships but it doesnt seem to work. 

Please help

Thanks

[v-yuta-msft]

@Anonymous ,

You should format your raw data as a table, not a matrix. Add a column header(name) in every column and make sure data type is same in every column. 

Community Support Team _ Jimmy Tao

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.