Forum Discussion
anterokarttunen
7 years agoFrequent Visitor
Never used powerbi desktop before, problem making query to table
Hey,
Been using powerbi desktop for 5 minutes. I am shocked that instead of SQL there is this DAX language.
Anyways, how on earth do you write a select on a table? Feels like I am back in school :D
Using this does not work: EVALUATE logic_app_tracked_runs
Figured it out! You have to refer this "powerquery M language" lmao
https://docs.microsoft.com/en-us/powerquery-m/table-functions
let
Source = Table.SelectRows(logic_app_tracked_runs, each [correlation_clientTrackingId_g] <> null)
in
Source
1 Reply
- anterokarttunenFrequent Visitor
Figured it out! You have to refer this "powerquery M language" lmao
https://docs.microsoft.com/en-us/powerquery-m/table-functions
let
Source = Table.SelectRows(logic_app_tracked_runs, each [correlation_clientTrackingId_g] <> null)
in
Source