Forum Discussion

lruboczki's avatar
lruboczki
Regular Visitor
10 years ago

Connect to Azure OMS (Operations Management Suite) from Power BI Desktop

Hi!   Is it possible to connect to Azure OMS from Power BI desktop? The built-in solutin of PowerBI in OMS is publishing the data only to Power BI Service, where I am not able to use multiple datas...
RafDelgado's avatar
RafDelgado
Icon for Helper II rankHelper II
9 years ago

I had a similar problem, I used Azure Automation to query the log analytics via powershell, exported it to csv and uploaded that to a private blob. Then imported the blob with the Azure Storage connector and gathered the OMS CSV content that way. Not ideal but did the job.

 

Also looked at directly calling the api but authenication wasn't supported :(

pepe80's avatar
pepe80
New Member
9 years ago

Hi,

 

I would really appricate if you could post the script which posts the csv to the azure blob, as I am not a very skilled scripter. Thank you for the input, anyhow.

 

Best Regards

 

  • hdnicholas's avatar
    hdnicholas
    New Member
    9 years ago

    Hello Pepe80, I have completed a script that does what you are asking. Although, it usses the Azure PowerShell Operational Insights cmd lets. As well, uses the OMS query. There will need to be slight modifications on your side regarding the query and the outputs. Are you okay with this? Also, you will need the correct PowerShell Modules added.