Unable to load Power BI optimisation reports.

[thebeardedgamer]

🐛 Problem

Unable to load optimisation reports.

👣 Repro steps

I have deployed FinOps hub v12 with ADX and have loaded the KQL reports into PowerBI.
I am using Version: 2.143.878.0 64-bit (May 2025) of Power BI, so I get this error when loading the reports:

After closing this error, the CostSummary report loads fine, with the exception that I can’t get to the public price units:

My developer workstation is in a restricted environment which blocks the network access to this. This isn’t my main problem, but I wonder if it is contributing (see further down).
My main issue is with the two optimisation reports. I load the report, enter my ADX cluster URI and get the following error:

Closing that error opens the report (in this case, Workload optimisation) but then gives me a credential error:

I’ve verified that the account I am using has viewer access on both DBs. If I open a blank report and connect to the Hub database, I can get recommendations data from the v1_2 table using this account:

Going back to the out of the box workload optimisation report, and into power query, I see this error:

Going to the error takes me to the Source step:

Troubleshooting:

1. I’ve verified the recommendations export is working and there is data in the ingestion folder
2. Verified database credentials on both databases, including a test connection
3. Verified the correct ADX cluster URI is in the report Setup

🤔 Expected

The data for optimisations should load.

🙋‍♀️ Ask for the community

1. Any ideas on the error?
2. Does not being able to load the public pricing table cause issues with the recommendations data?
   Thanks.

[flanakin]

The Power BI version issue is clear. The only way to resolve that is to upgrade. Not much we can do unless you want to grab the older version of the reports before May 2025. Luckily, you can ignore that, as you've seen. So you should be fine.

The PricingUnits error sounds like a network issue. To confirm, check the auth used for GitHub and confirm it's anonymous. Worst case scenario, you can download the PricingUnits.csv file from the FinOps toolkit release and load it directly. You can also remove it, but that would require updating other queries. I'd have to check to confirm which ones.

I can't explain the access denied error, but that does seem separate from the ARG error you're seeing. If this is causing issues connecting to Data Explorer, I would recommend filing a support request with the Data Explorer team to get it resolved.

For the ARG error (The import AzureResourceGraph.Query matches no exports), the only thing I can guess is that there's an issue loading the ARG connector or possibly the network connection. If you're on a firewall, I wonder if the URL is being blocked. I'm not familiar with how to best test that theory other than to get a tool that can monitor network traffic to see if certain calls are failing. A network admin would know. If that's not the issue, then I would try a support request with the Resource Graph team.

If the ADX and ARG teams can't help, then fall back to the Power BI team. They may have additional tools to help. This is something happening outside the report, so I'm not sure we can do anything.

Let us know what you figure out!

[thebeardedgamer]

Thanks @flanakin, appreciate the guidance.

re PricingUnits: I had the same thought and downloaded the file manually and changed the source step to point to the file, this got around the issue (for now).

re ARG Error: I think you are right. I have since requested that the list of required Power BI URLs is allowed into the developer desktop environment. I believe that the ARG connector is not included in the base installer, but is called via a URL and as I cant reach that, it's failing. The ARG connector is not in the list of connectors that I see when selecting "Get Data" in my env, so I think that supports my theory. Still waiting for the URL allow to be done, will see how that goes.

Are you aware of the differences between the recommendations data that comes out of the Cost Manager exports, and that which comes from the ARG queries in the report? I believe that the ARG queries are hitting the ARG service directly and not the ADX DBs, perhaps the cost manager exports includes just the cost value of the optimisations and then the ARG queries collect data about the resources in question?

Thanks again, will update as I learn more.