locked
Loosing calculated columns and measures in PowerPivot/Power Query RRS feed

  • Question

  • I import from an Excel file via Power Query into the data model. Then adding calculated columns and measures in PowerPivot. Next time I open the workbook, the connection is gone, the Pivot tables flattened, and the calc columns and measures are gone! I’ve seen this problem in other forums even for 2013, but it started for me with 2016 – ProPlus.



    Saturday, October 17, 2015 8:30 AM

Answers

  • http://connect.microsoft.com/SQLServer/feedback/details/808079/powerpivot-com-exception-cannot-open-model
    http://stackoverflow.com/questions/21998002/vsto-addin-calling-excel-connection-breaks-powerpivot/23004501#23004501

    Monday, October 26, 2015 1:32 AM