Log Analytics credentials

[DolEgon22]

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!

[v-caliao-msft]

@DolEgon22,

Here is a document descibes integrating OMS and Power BI, please check if it helps or not.

https://blogs.technet.microsoft.com/msoms/2016/03/31/integrating-oms-and-power-bi/

Regards,

Charlie Liao

[DolEgon22]

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]

@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.