🐛 Problem

All the AOE workbooks that are used to analyze Reservations (Reservations Potential, Reservations Usage and Benefits Simulation) are generating query errors when the Instance Size Flexibility (ISF) switch is turned on. This is caused by an issue in the externaldata operator in the workbook queries, when requesting ISF data from the https://aka.ms/isf URL. This URL redirects to an Azure blob storage URL.

👣 Repro steps

1. Open one of the above mentioned workbooks, for example Reservations Potential
2. Turn the Instance Size Flexibility switch on (see screenshot below)
3. Some of the workbook tiles show a "Query partially succeeded; results may be incomplete or incorrect." error (see screenshot below)

🤔 Expected

The Workbooks should load data without any error.

📷 Screenshots

ℹ️ Additional context

As a work/around, If I edit the Workbook code and replace all the occurrences of the https://aka.ms/isf URL by the URL of the Azure Blob that aka.ms redirects to, the workbook works fine.

🙋‍♀️ Ask for the community

We could use your help:

1. Please vote this issue up (👍) to prioritize it.
2. Leave comments to help us solidify the vision.