Get data from pivoted excel

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

Anonymous

Hi Lydia,

in my excel, i don't find the option of "show queries" see below.

Can i share you the excel file privately?

vjnvinod,

I am using Excel 2016, please check this sample Excel file.  You should find same option in Power Query tab of Excel 2013/Excel 2010.

Regards,
Lydia

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

vjnvinod,

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

Regards,
Lydia

Anonymous

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

vjnvinod,

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

Regards,
Lydia