I need help with the ADX Dashboard

[ctsaund85]

I'm not sure what's going on, but I'm having trouble with the ADX Dashboard showing any data. Before I got a 401 error message, I deleted the data source and added it again, now I'm getting error message "Configured data source not available"

My pipeline is working; I've checked the storage account and can see the correct files in the correct places. But I'm not sure what to do here. Does anyone have any ideas that can help me? Thanks.

[francesco1119]

Can you help me help you?
I would like to know how you were able to port the Power BI dashboards to ADX.
I know there is some JSON I need to import. Where can I find it?

[ctsaund85]

@francesco1119, for the image of the dashboard I posted, I just followed the instructions from here. https://learn.microsoft.com/en-us/cloud-computing/finops/toolkit/hubs/configure-dashboards?tabs=data-explorer

There is a link to a dashboard template that you download, then import into ADX.

[DakotaB75]

¿What this error usually means?
This error usually does not mean that data is missing from Storage
In FinOps Toolkit, ADX dashboards query ADX tables and KQL functions, not raw files
After deleting and recreating the data source, the dashboard can fail if the expected logical objects no longer exist or are not accessible

Why this happens
This typically occurs when one of the following is missing or was not recreated:

• Expected ADX tables
• Ingestion mappings
• Dashboard-related KQL functions
• Permissions on the ADX cluster

In this state, the dashboard template cannot bind to its configured data source and returns Configured data source not available

Running these usually identifies the issue:

.show tables
.show functions
If the expected tables or functions are missing, the dashboard will not resolve the data source even if ingestion is working...

If you can confirm:

• whether the expected tables exist
• whether any dashboard functions are present
  we can identify exactly what needs to be recreated
  Podemos reviewing this setup flow to see how this failure mode could be made clearer for users...

[ctsaund85]

@DakotaB75, Thanks for your help!

I ran those two queries, and this is what I got...

.show tables

.show functions

It looks like the tables don't exist.

[DakotaB75]

Thanks, the screenshots help
Nothing is broken this is how the FinOps ADX schema works.
Costs and Prices are KQL functions/views, not physical tables, so .show tables won’t list them.

Your data is already ingested. To verify it, query the raw cost table directly:

ActualCosts_raw
| take 10

If that returns rows, ingestion is correct and the dashboards will work.
For pricing data, inspect the Prices KQL function in the UI it is computed from reference tables (e.g. PricingUnits, Services, etc.), not always from a Prices_raw table...

[ctsaund85]

@DakotaB75, Unfortunately that command returned an error.

[DakotaB75]

Root Cause
The error occurs because the Hub database is being queried, but I see the raw tables (ActualCosts_raw) are located in the Ingestion database. In ADX, tables are applied to the database, not the entire cluster.

Option 1: Switch databases in the UI
Select Ingestion (not Hub) in the left panel and run:

ActualCosts_raw
| takes 10

Option 2: Fully qualify the table
Run this from any database:

Ingestion.ActualCosts_raw
| takes 10

• The panels query KQL functions in Hub (Costs, Prices).
• These functions reference raw tables in Ingestion.
• If the dashboard data source was recreated, but the database context didn't match, ADX reports:

Configured data source unavailable.

This confirms:

• Ingestion is working.
• The schema is correct.
• The problem is with the database context linking, not a lack of data.

[RolandKrummenacher]

Hi @DakotaB75,

Thanks for taking the time to look into this. I need to correct a few points in your guidance because it can lead people in the wrong direction.

The dashboard and its queries are designed to run against the Hub database
All standard Toolkit queries should be executed in the Hub database and should use the Hub functions such as Costs() and Prices(). The Hub is the supported query surface for reporting and dashboards.

Do not query the Ingestion database directly for normal troubleshooting
The Ingestion database contains raw and intermediate artifacts. Querying it directly is not the intended operational path for the dashboards and it can produce confusing or misleading results, especially if someone starts building queries against raw tables.

ActualCosts_raw is not a general purpose table
ActualCosts_raw in the Ingestion database is reserved for special legacy scenarios and should not be used for normal reporting or validation. Using it as a primary diagnostic step is not recommended.

If the dashboard shows “Configured data source not available” after re adding the data source, the next step should be to validate that the data source is connected to the Hub database and that the expected Hub functions are accessible, rather than switching the dashboard to Ingestion or querying raw tables.

[francesco1119]

Now I see why the Power BI dashboards are so fast: the calculation is done in KQL at Azure Data Explorer Cluster level.
Not in DAX at Power BI level.

[RolandKrummenacher]

Hi @ctsaund85,

Just to make sure I understand the situation correctly: the dashboard was working as expected, and the issue only started after you removed the existing data source and added it again. Is that correct?

[ctsaund85]

@RolandKrummenacher, I did just notice that my Hub database is 0 Bytes. Not sure if that's by design or if I have something misconfigured.

[RolandKrummenacher]

The Hub database is always 0 Bytes as it doesn't hold any data.

[RolandKrummenacher]

I understand that you where able to change the data source and set it to your Hub database of your cluster. Not sure what the issue can be here. Are you running on v12 of the FinOps Toolkit? Can you check with a browser in private mode?

[ctsaund85]

@RolandKrummenacher, I tried with my browser in private mode and got the same as before. I'm not sure about what version I'm running. I used the Deploy template from here (https://microsoft.github.io/finops-toolkit/hubs#deploy) and I deployed it a few weeks ago. It's basically a POC for me at the moment, so I can always blow away what I have so far and try and redeploy.

[RolandKrummenacher]

@ctsaund85 Unfortunately, I can't reproduce your error. I've downloaded the dashboard.json like you've done it and created a new dashboard in my environment and the charts load correctly. I guess you have already double checked whether your cluster URI is correct, right?

[francesco1119]

I was able to reproduce the error.

on ADX go to Dashboards > Import dashboard from file

Pickup the JSON file that I'm putting here in attach
finops-hub-dashboard (1).json

Now the dashboards are completely broken:

Now go to Data Source > Edit, you will see that the Cluster URL is the default one https://ftk-mf.westcentralus.kusto.windows.net/

change that and put instead your Cluster URL.
Then click Connect and Apply.

Wait a few seconds and the data will be rendered.

[RolandKrummenacher]

That is basically step 4 of the instructions @ctsaund85 has followed: https://learn.microsoft.com/en-us/cloud-computing/finops/toolkit/hubs/configure-dashboards?tabs=data-explorer

[francesco1119]

So some permission maybe?

[ctsaund85]

@francesco1119, I have no idea why, but when I used the dashboard JSON that you provided, removed your data source and added mine. Everything is working now!

Thank you all for your help. I'll start working around with this and see if I want to expand it to the rest of my subscriptions.