Forum Discussion
Importing Data models from power BI service into excel and using pivot tables
ankitpatira Thank you for the response.
By using import I am able to see hierarchies in excel but I cannot put calculated columns in the values section. Even the numeric columns that come from sql server cannot be put in the values section.
My client wants to be able to form their own reports in excel using model imported from Power BI. How will this be possible if none of the numeric columns can be put in the values section?
Hi sadhnabatra,
In excel, I am not able to put calculated columns in the values section, however, I am able to put numeric columns that come from SQL Server in the values section. Could you please post sample data of your numeric columns?
in addition, according to my knowledge, calculated column are always used in the ROWS, COLUMNS, or FILTERS area of PivotTable but not in the values section.
Thanks,
Lydia Zhang