Connecting azure analtics workspace with power bi?

[thakurabhay9038]

There is a business need to get usage metrics information of visual level in power bi.Like how may times a person has seleceted a particular  value from slicer,which value qas selected.How many times aperson clicked on particular bar chart and who has clicked.So for this  we are coonecting azure analytics workspace with power bi workspace .But we need to query the results in azure analytics workspace using kql.Can anyone  write sample query for checking who has clicked on slicer ,which value was selected and how many times the value was selected?

[v-yiruan-msft · Accepted solution]

Hi @thakurabhay9038 ,

Please review the following links and check if they are what you want.

Using Azure Log Analytics in Power BI

Export Log Analytics data to Power BI

Using Power BI to Query Log Analytics

Best Regards