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 datasets to a report.
Laszlo
8 Replies
I sure hope it is coming soon. Pushing it to the 0365 Power BI is great, but I need to publish some of these nice charts and iframe them into another web page. That means I need to use the newly minted Azure service PoweBI embeded. This means I need a connector in PowerBI Desktop to design and upload my charts.
v-micsh-msftMicrosoft Employee
Hi Iruboczki,
Currently I don't think it is available to connect to Azure OMS with Power BI Desktop, as it is not listed as an available data source under official document:
Data sources in Power BI Desktop
By the way, we could submit an idea in the following website:
https://ideas.powerbi.com/forums/265200-power-bi-ideas
And hope this feasure would come up soon.
Regards
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 :(
