Get source queries from PowerPivot/1103 Compatibility Mode

lbendlin doesn't look that way, the last thing I can see documenting which compatibility mode goes with which version is the SQLBI article above; anything > Excel 2013 is 1103.

We're using the M365 version so fairly recent.

I saw something about the level being higher in PowerQuery but we've not got the time or desire to make that switch just to extract the queries before ultimately dumping these workbooks.

We've recently had an issue with a high priority measure being shared incorrectly so this is really an exercise in damage control and to strengthen the business case.

We have accesss to Gartner through work so likely going to take it to their technical analysts, seems to be the only option as just losing time on this one daily.