Forum Discussion

DolEgon22's avatar
DolEgon22
Advocate II
8 years ago

Log Analytics credentials

Hi Everyone,

 

We have previously used the export function to Power BI (M Query) option when using Log Analytics for Application Insights. We were able to build reports based on this export and then publish to Power BI. In order to refresh in the service, we had to generate an API Key (in Application Insights), and could then use Basic credentials and put that key in the User Name field. It then refreshes with no problem. 

 

Now we are using the latest update to OMS and are using Log Analytics there as well. It's the same Log Analytics hat AppInsights uses, so the process is exactly the same (export to Power BI M Query). However, once we publish to Power BI service, there is no option in OMS to generate an API key. As a result, I do not have a simple way to refresh a dataset generated from OMS. 

 

Has anyone else run into this yet? Any suggestions? 

 

Thanks!

3 Replies

    • DolEgon22's avatar
      DolEgon22
      Advocate II

      No, this does not help. We've been integrating Power BI and OMS the old way (as outlined in the link you sent) as well as the new--and better way--using Log Analytics.

       

      My question is specific to OMS, so I'll cross post on the appropriate forum. 

       

      Thanks!

      • adamlen's avatar
        adamlen
        New Member

        DolEgon22 

         

        were you able to work this out? Trying to access data from log analytics now from PowerBI but would like to use an Azure Service Principal to present the data as a dashboard for the team.