Connect PowerBI to Log Analytics Workspace on Azure

krishnamohan183 , refer if this can help

https://www.red-gate.com/simple-talk/blogs/using-log-analytics-to-connect-to-power-bi/

https://github.com/uglide/azure-content/blob/master/articles/log-analytics/log-analytics-powerbi.md

refer if needed

https://learn.microsoft.com/en-us/power-bi/transform-model/log-analytics/desktop-log-analytics-configure

https://learn.microsoft.com/en-us/power-bi/transform-model/log-analytics/desktop-log-analytics-overview

Hi, krishnamohan183 

Log Analytics queries can be exported to M and used in Power BI directly. After running a successful query, select the Export to Power BI (M query) from the Export button in Log Analytics UI top action bar. Log Analytics creates a .txt file containing the M code that can be used directly in Power BI.

For more details, please refer to the following official article, which focuses on ways to feed data from Log Analytics to Microsoft Power BI to create more visually appealing reports and dashboards.

https://learn.microsoft.com/en-us/azure/azure-monitor/logs/log-powerbi 

Best Regards,
Community Support Team _ Eason

Hi v-easonf-msft is there anyway to create a live connection or direct query Log Analytics using the M query option that you mentioned? I am looking to avoid having to import the data from log analytics. I noticed there is a connection for Azure Data Explorer, but I haven't seen one for Log Analytics, other than using the M Query. I also tried exporting to a Power BI dataset but that seems to fail every time.