Forum Discussion

Impactful Individual

8 years ago

Get data from pivoted excel

hi, is it possible for Power querty to load pivotted excel and unpivot the excel in power query?

Impactful Individual

8 years ago

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

Anonymous

Not applicable

8 years ago

vjnvinod,

As my previous reply, please use File -> Import -> Excel Workbook Contents option in Power BI Desktop.

Regards,
Lydia

vjnvinod
Impactful Individual
8 years ago
Anonymous

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.
- Anonymous
  Not applicable
  8 years ago
  vjnvinod,
  
  Could you please share the Excel file so that I can repro?
  
  Regards,
  Lydia
  - vjnvinod
    Impactful Individual
    8 years ago
    Anonymous
    
    unfortunately the excel file contains confidential information and won't be appropriate to share.
    I see the link you have shared, according to that looks like its not possible with a normal excel pivot