Forum Discussion
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
Helper II
Helper III 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 :(
dkay84_PowerBI
Microsoft Employee
Microsoft EmployeeRafDelgado that was going to be my suggestion, as I have done this as well. Write your OMS logs to Azure Blob (as csv) with powershell and connect to blobs from Power BI. Not ideal but definitely doable.