Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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>
Solved! Go to Solution.
Hi @Anonymous,
What do you mean join the M queries? Do you want to combine the two datasets returned by two queries? If so, you can load them separately into desktop, then, merge or append them in Query Editor via UI.
Regards,
Yuliana Gu
Add the queries as you normally would. Then in the relationships pane you can join the datasets together by specifying which columns you need to Join.
Tan
Hi @Anonymous,
What do you mean join the M queries? Do you want to combine the two datasets returned by two queries? If so, you can load them separately into desktop, then, merge or append them in Query Editor via UI.
Regards,
Yuliana Gu
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
100 | |
89 | |
68 | |
61 |
User | Count |
---|---|
150 | |
120 | |
100 | |
87 | |
68 |