Forum Discussion
Community ChampionDataflows / PQO: query dependencies on other queries, parameters, functions?
Power BI TeamHi otravers,
You can use Get-Data and then choose blank query. There you can paste the M script from Power BI Desktop.
Another alternative is edit an existing M script by clicking on the right button on a query then choose 'Advanced editor'.
Hope that it helps.
Thanks,
Yaron
Community Championyaronc I know, I mentioned starting from a blank query in my post. As I said that's not nearly as efficient as done a single copy/paste to get all dependencies imported in one swoop.
- musicbydannyd
Advocate IV
otravers, finally got around to testing Dataflows. Pasted this simple dynamic EndDate parameter from Power BI to a blank query:
let Source = #datetime(Date.Year(Date.AddDays(DateTime.LocalNow(),-1)), Date.Month(Date.AddDays(DateTime.LocalNow(),-1)), Date.Day(Date.AddDays(DateTime.LocalNow(),-1)), 23, 59, 59) in Source
and Dataflow insists on converting to a table before considering it "valid". Anyone know a workaround?
Thanks, DD
- otravers
musicbydannyd right click the name of the parameter in the PQO editor and uncheck Enable load before saving it, and this will no longer happen. Same thing with functions. They're both supported but not yet fully handled by the UI.
- musicbydannyd
otravers, that did the trick! Makes sense now, given loaded queries are converted to csv in Azure Gen 2...
Thanks so much, DannyD
