Forum Discussion
Get data from pivoted excel
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,
Lydia
Anonymous
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,
LydiaAnonymous
i did tried that, but it doesn't helps, see the below migration failed
what i am asking is not about queries or model, its a pivoted xlsm report for which i need the source data to be imported into Power BI
currently, how i am managing is by double clicking on the pivot content and getting into source data and then loading, which is time consuming and for me to do every time the same routine.
Could you please share the Excel file so that I can repro?
Regards,
Lydia