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
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
      8 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

      • Anonymous's avatar
        Anonymous
        Not applicable
        8 years ago

        vjnvinod,

        Could you please describe more details about how the Excel file is created? You can review the steps I use to create the Excel file.

        Use this option to connect to SQL in Exceluse the load option to load data to data modelselect "Add this data to the Data Model" option

        After the above steps, I create a pivot table as shown in first image  and save the Excel file in xlsm format. And I successfully connect to the Excel in Power BI Desktop.

        Regards,
        Lydia