Import Calculations from xml using library tab

Topics: Resolved
Aug 11, 2016 at 4:10 PM
Hi there,

According to the documentation, it looks like you can import measures directly from a xml file into the data model. However, I am not seeing either the Calculations or Library tab to attempt this.

Is this functionality still present?



Running Excel x64 2016
Coordinator
Aug 11, 2016 at 4:50 PM
Is it an Excel Data Model (Power Pivot)?
Aug 12, 2016 at 5:17 PM
That's correct.
Coordinator
Aug 17, 2016 at 10:03 PM
If you look at the features matrix near the end of the home page then you'll see that unfortunately adding MDX calculations into a PivotTable connected to the Excel Data Model isn't supported by Excel unfortunately:
https://olappivottableextend.codeplex.com/

If I could enable this feature, I sure would!
Aug 18, 2016 at 1:15 AM
What a bummer. I figured as much, but was still holding out in hope.

With the frequency that power pivot data models corrupt, it's a shame that Microsoft doesn't make importing measures easier. BTW (and to exhaust all options), you wouldn't know of any other method to accomplish my goal of importing measures in bulk?