Forum Discussion

vjnvinod's avatar
vjnvinod
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?
Need Help
Show and Tell
vjnvinod's avatar
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's avatar
Anonymous
Not applicable
8 years ago

vjnvinod,


Could you please share the Excel file so that I can repro?

Regards,
Lydia

  • vjnvinod's avatar
    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

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      vjnvinod,

      You can share a Excel file containing dummy data here.

      Regards,
      Lydia

      • vjnvinod's avatar
        vjnvinod
        Impactful Individual
        7 years ago

        Anonymous

         

        Source of that pivot is SQL server, hence the sampling is not possible, because i don't have acess to that server. I have only acess to the Xlsm file