Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
krishnamohan183
New Member

Connect PowerBI to Log Analytics Workspace on Azure

Hi All

 

I have some Azure Components and would like to visualize some of the resources and their components. I have log analytics workspace, where all my logs are already going to that workspace.

 

Now I want to visualize and then automate the refresh everyday. Is there any connector in GetData from PowerBI to Log Analytics, just like we have to Connections between PowerBI and LogAnalytics.

 

How can I achieve it if I do not have them.

3 REPLIES 3
nderitis
Regular Visitor

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.

v-easonf-msft
Community Support
Community Support

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.