Forum Discussion
Solved
Importing an excel table into Power BI - Convert to List?
Hi, I have data in an excel file that I want to import into a Power BI report, unfortunately the data is in a table not a list. For example: Product Jan 2020 Feb 2020 Mar 2020 2040...
Don't worry, found the solution.
In edit query, select product column, right click, "unpivot other columns".
Don't worry, found the solution.
In edit query, select product column, right click, "unpivot other columns".