[PowerBI] Rate Optimization Report (KQL Version) Prompts for Azure Blob Storage Access to `ccmstorageprod.blob.core.windows.net`

[AErmie]

🐛 Problem

When trying to view/load the RateOptimization.kql.pbit file locally (in PowerBI Desktop), the report prompts for Azure Blob Storage access. However, it does not prompt the user to provide the target Storage Account. Rather, it seems to be hard-coded to ccmstorageprod.blob.core.windows.net

Cancelling this prompt results in the following query error:

InstanceSizeFlexibility
Credentials are required to connect to the AzureBlobs source. You'll need to refresh and provide credentials to continue. (Source at https://ccmstorageprod.blob.core.windows.net/costmanagementconnector-data/AutofitComboMeterData.csv.)

👣 Repro steps

1. Download the latest Rate optimization report
2. Open the RateOptimization.kql.pbit file in PowerBI Desktop
3. Provide details about the Cluster URL
4. See prompt about Storage Account access

🤔 Expected

The report should not prompt for access to a Storage Account, since it is a KQL version of the report. If access to a Storage Account is actually require, prompt the user to provide the target Storage Account information. Also update the documentation to clearly explain what is needed/expected.

ℹ️ Additional context

The FTK deployment configuration we are using, is the "private" mode, with an ADX cluster.

🙋‍♀️ 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.

[flanakin]

@AErmie This is expected. This is where we get the instance size flexibility data. There's a newer API we can use, but it will require a bit of work to switch over to it and we'll still have the same issue with needing to specify auth.

For the time being, please use anonymous auth for this one and you should be good. That should be covered in docs. Let us know if we need to make that more discoverable by adding it somewhere else.

[AErmie]

Thanks @flanakin. I was able to get it to work using anonymous.

As for the documentation, I see on the How to set up Power BI page, under the Set up your first report section, Step 4 bullet 4: "https://ccmstorageprod... – Anonymous access. This URL is used for reservation size flexibility data."

While I obviously missed that, it is there. However, my default thought is to check the report specific page documentation. Perhaps each respective report page (ie. Rate optimization report) could also be updated with details specific to that reports' data sources, etc.