Problem in connecting to multiple OMS workspaces

[ramesh286783]

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

[v-chuncz-msft]

@ramesh286783,

Take a good look at the Advanced Editor and study to use argument options of Web.Contents.