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
7 years ago

Anonymous

 

 while doing that, it ask me for server name, i think this will not work, i have only option of double clicking on the pivot and extracting it to a new excel and save it

 

 

 

Anonymous's avatar
Anonymous
Not applicable
7 years ago

vjnvinod,

You can follow my previous steps to make a test with your own SQL.

Regards,
Lydia

  • vjnvinod's avatar
    vjnvinod
    Impactful Individual
    7 years ago

    Anonymous

     

    when i followed your steps it asked me for the login credentials

  • Anonymous's avatar
    Anonymous
    Not applicable
    7 years ago

    vjnvinod,

    Yes. You would need to have access to the SQL database you  connect to.

    Regards,
    Lydia