Greetings I am new here, am not sure if this ha been posted eariler, am trying to pull data from OMS and pushing to PowerBI to get better better and custom visilization, eariler i created a table stroage and pushed all my data to it, later on i connceted with power bi desktop, due partitionkey and Rowkeys complex behavior i dropped the idea,
Now i am trying to export the m queries from tw differnet workspaces and trying to join them and m not sure how do i get it done help is much appricaited
where XXX is workspace
<let AnalyticsQuery =
let Source = Json.Document(Web.Contents("https://api.loganalytics.io/v1/workspaces/XXXXXXXXX",
[Query=[#"query"="Update
| where OSType!=""Linux"" and Optional==false
| summarize hint.strategy=partitioned arg_max(TimeGenerated, *) by Computer,SourceComputerId,UpdateID
| where UpdateState=~""Needed"" and Approved!=false
| render table",#"x-ms-app"="OmsAnalyticsPBI",#"timespan"="2018-08-02T04:12:11.000Z/2018-08-31T19:12:11.000Z",#"prefer"="ai.response-thinning=true"],Timeout=#duration(0,0,4,0)])),
TypeMap = #table(
{ "AnalyticsTypes", "Type" },
{
{ "string", Text.Type },
{ "int", Int32.Type },
{ "long", Int64.Type },
{ "real", Double.Type },
{ "timespan", Duration.Type },
{ "datetime", DateTimeZone.Type },
{ "bool", Logical.Type },
{ "guid", Text.Type }
}),
DataTable = Source[tables]{0},
Columns = Table.FromRecords(DataTable[columns]),
ColumnsWithType = Table.Join(Columns, {"type"}, TypeMap , {"AnalyticsTypes"}),
Rows = Table.FromRows(DataTable[rows], Columns[name]),
Table = Table.TransformColumnTypes(Rows, Table.ToList(ColumnsWithType, (c) => { c{0}, c{3}}))
in
Table
in AnalyticsQuery>
