Forum Discussion
Connect to Azure OMS (Operations Management Suite) from Power BI Desktop
Im dealing with same problem as I wanted to create few log queries as separate OMS datasets in powerBI and publish those into company Intranet portal and my plan crashed on fact that I can access those datasets in powerBI service only which has the limitation you mentioned.
Next step is try using Data Catalog feature which requires enterprise license but its worth it.
I notice that from web view the Dataset can be "Analyzed in Excel" so this enabled me using powerQuery to save this output as Data Catalog.
- RafDelgado
Helper II
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 :(
Wow, thats interesting concept. It reminds me existence of Logic Apps where I can do similar way if Flow style :) so I will give it a try.
thanks for hint.
JK
- dkay84_PowerBI
Microsoft Employee
RafDelgado 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.
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
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.
