Unable to load Power BI optimisation reports.

🐛 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.

Start by reproducing the failure in the Workload optimisation and other optimisation reports after entering the ADX cluster URI. Inspect the Power Query Source step and compare it with a blank report that successfully reads the v1_2 table. Done means the optimisation data loads with the documented credentials and cluster configuration.