azurepowerbipowerbi-datasource

How to link Power BI to Azure Log Analytics Workspace to analyze data from LAW in Power BI?


Does anyone know or have a link to the documentation which describes of how to connect Power BI to Azure Log Analytic Workspace Query (permanently) to be able to analyze LAW data in Power BI on a daily basis ?

Thanks in advance!

Export data to Excel first but I need a continuous access in Power BI to LAW data without exporting and importing data each time I need to analyze them.


Solution

  • Thanks for the inputs @wenbo and I did the same way by following below steps:

    Firstly after executing the Query In Log Analytics Workspace:

    enter image description here

    Now a M query will be downloaded and copy that.

    Steps in Power Bi:

    enter image description here

    enter image description here

    enter image description here

    enter image description here

    Output:

    enter image description here

    One another way is by try using Azure Data explorer( i.e by sending the data to Azure Data Explorer and then use the cluster in Power Bi. )