I want to perform a PoC for FinOps Hub with Azure Data Explorer and also use the Power BI KQL Templates. I was able to deploy the FinOps Hub, create Dashboard in the Azure Data Explorer, but when I try to use the Power BI KQL template (currently just Cost Summary), I cannot connect to the Data Explorer from Power BI template. When trying to connect from the PBI to the ADX data source, the only option I see is for the Organizational Account. I get the "Access Denied" error and I cannot connect.

I want to perform a PoC for FinOps Hub with Azure Data Explorer and also use the Power BI KQL Templates. I was able to deploy the FinOps Hub, create Dashboard in the Azure Data Explorer, but when I try to use the Power BI KQL template (currently just Cost Summary), I cannot connect to the Data Explorer from Power BI template. When trying to connect from the PBI to the ADX data source, the only option I see is for the Organizational Account. I get the "Access Denied" error and I cannot connect.