charles sterling on 04 Aug 2018 03:20:21
I would like to be able to create an entity based off of a custom SQL Query instead of having to use the Power Query tools. The problem I am having is that one of the tables I am working with is too large and results in a timeout when Dataflows tries to bring it in. I think that a custom SQL Query will alleviate this issue by allowing me to prefilter my data before it comes into Dataflows.
Administrator on 19 Jan 2019 03:22:09
We shipped Native SQL query support. You can learn more about this feature here: https://powerbi.microsoft.com/en-us/blog/power-bi-dataflows-january-updates/
- Comments (11)
RE: Dataflows from Custom SQL Query
If we can't use SQL native queries, Dataflow is useless for us...