The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event: Join us in Stockholm, September 24-27, 2024.
Save €200 with code MSCUST on top of early bird pricing!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
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
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the July 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
109 | |
67 | |
46 | |
41 |
User | Count |
---|---|
188 | |
86 | |
77 | |
74 | |
60 |