Forum Discussion
Exporting data from excel( calculated fields to powerpivot) to power BI Desktop
Hello,
Please, I need help to export data from excel in powerpivot (included calculated fields) to powerpivot. An exporting of calculated fields is not going on. Please i need your experience for help me to solve this problem..
thanks.
Hi wilfred,
Please click File -> Import -> Excel workbook contents, this way, you can easily import Excel workbooks that contain Power Query queries, Power Pivot models (including calculated fields), and Power View worksheets into Power BI Desktop.
Which workbook elements are imported?
Best regards,
Yuliana Gu
1 Reply
v-yulgu-msftMicrosoft Employee
Hi wilfred,
Please click File -> Import -> Excel workbook contents, this way, you can easily import Excel workbooks that contain Power Query queries, Power Pivot models (including calculated fields), and Power View worksheets into Power BI Desktop.
Which workbook elements are imported?
Best regards,
Yuliana Gu