Trying to connect IcM with Power BI to produce the IcM Stats over Power BI but unable to do so

[v-sivish]

I'm trying to setup a connection between IcM and Power BI but unable to find any Analysis service connecting the two or any other service to bridge the two. Please help. 

Thanks! 

[v-yulgu-msft]

Hi @v-sivish,

Do you want to fetch data from ICM web page in desktop?

If so, you should firstly know how the ICM web page is developed and which API it supports. And here are some articles for your reference to connect to web source:

API Strategies with Power BI

Analyzing Web page data using Power BI Desktop (tutorial)

Regards,
Yuliana Gu

[v-sivish · Accepted solution]

Thanks @v-yulgu-msft, I raised the matter to the IcM Support Team and they guided me well to use the IcM Cluster data warehouse via Kusto using which it was populated successfully over Power BI. Following links were of great help to me: 

• Data Warehouse Info - Kusto Cluster (SQL Warehouse Has Been Deprecated)

• https://kusto.azurewebsites.net/docs/tools/tools_powerbi.html?q=powerbi