Forum Discussion
Anonymous
4 years agoNot applicable
SQL Statement to query a Power BI Dataflow
Hello everyone I've looked everywhere for an answer to this, I couldn't find a working example. I have a very large Power BI Dataflow set up, will all Sales history over 10 years. My report, tha...
- 4 years ago
You should be able to add a filter step in your query editor to select just 2021 data. I don't think the dataflow necessarily uses SQL but that shouldn't matter.
Your query will look something like this with the new step.
let Source = PowerBI.Dataflows([]), #"xxxxxxxxxxxxxxxx" = Source{[workspaceId="xxxxxxxxxxxxxxxx"]}[Data], #"yyyyyyyyyyyyyyyy" = #"xxxxxxxxxxxxxxxx"{[dataflowId="yyyyyyyyyyyyyyyy"]}[Data], #"Sales" = #"yyyyyyyyyyyyyyyy"{[entity="Sales"]}[Data], #"Filtered Rows" = Table.SelectRows(#"Sales", each [sales_date] >= #date(2021, 1, 1)) in #"Filtered Rows"
Anonymous
4 years agoNot applicable
Thanks amitchandak
Does that mean it's impossible to send a complex query with JOIN etc, to be executed on the Dataflows side before the data is sent back to Power BI ?