Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
If an end user provides many spreadsheets with data oriented horizontally instead of vertically (see image) is there any way to import this into Power BI?
Power BI seems to normally expect that a single column represents a single list of data values. In this case rows represent the lists of values.
Solved! Go to Solution.
import it in as is and then use the transformations in Power Query to transpose it / filter out blanks / pivot it - etc
http://radacad.com/pivot-and-unpivot-with-power-bi
Proud to be a Super User!
Indeed. In this case, unpivot would be the better option.
import it in as is and then use the transformations in Power Query to transpose it / filter out blanks / pivot it - etc
http://radacad.com/pivot-and-unpivot-with-power-bi
Proud to be a Super User!
Indeed. In this case, unpivot would be the better option.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
107 | |
100 | |
80 | |
63 | |
58 |
User | Count |
---|---|
148 | |
111 | |
94 | |
84 | |
67 |