Forum Discussion

ramesh286783's avatar
ramesh286783
Regular Visitor
8 years ago

Problem in connecting to multiple OMS workspaces

Hi,

 

I'm trying to import an OMS (Operations Management Suite) Log Analytics query into PowerBI Desktop. The query basically uses union operator to pull data from the existing and other OMS workspace to summarize/visualize. 

 

Example given below:

union workspace("/subscriptions/xxx-test-dummy-yyyz.djhs-203/resourcegroups/r3test-d51/providers/Microsoft.OperationalInsights/workspaces/oms-ussc-r3test-d51").btsyn_CL

| where TimeGenerated >= ago(1d)

 

This query works perfectly fine in OMS Log Analytics. However, when I try to import this in PowerBI Desktop. I get the following error:

 

DataSource.Error: Web.Contents failed to get contents from *************(400): Bad Request