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.
