Forum Discussion
Get data from pivoted excel
hi,
is it possible for Power querty to load pivotted excel and unpivot the excel in power query?
15 Replies
vjnvinod,
Based on my test, you can import contents of pivoted Excel sheets to Power query.
If you need to import data model of Excel pivot, you can use File -> Import -> Excel Workbook Contents option in Power BI Desktop. There is a similar thread for your reference.
https://community.powerbi.com/t5/Desktop/Import-Excel-Pivot-to-PowerBI-Possible/td-p/136729
Regards,
LydiaAnonymous
My question is
Can i import an excel Pivot table into power bi as a table data source?
the one which you have shown is only the content of the pivot, not the actual source data
vjnvinod,
As my previous reply, please use File -> Import -> Excel Workbook Contents option in Power BI Desktop.
Regards,
Lydia
