Forum Discussion
dataflows: Error native query onprem oracle datasource
Hi Matthew,
Thanks for your answer. We didn't know about this limitation until we found it in a client's project. Hopefully it will be available in the short term because it's a pretty big limitation (as well as the fact that the one creating the dataflow has to be also the Gateway administrator, not just access to the datasource: https://docs.microsoft.com/en-us/power-bi/service-dataflows-on-premises-gateways).
BTW, that suggestion (or rather a fix) already has a couple more votes ;-)
I couldn't agree more with Anonymous, not supporting native queries basically limits me to exporting entire tables into the PBI dataset and when handling massive amounts of data plus SQL calcs, this is not what we want.
Hi Anonymous - Are you running into speficic scenarios where query folding isn't producing efficient native queries when you use PQ and M to build a query? Sharing some specific context in the idea (link above) would help the Power BI team understrand the impact of this gap.
Hi MatthewRoche - just to provide a quick example: when selecting a list of active tickets generated within the last 12 months, my database contains tickets generated since 2001. Instead of extracting 450 rows using my Oracle servers as the first layer, I have to extract a list of all tables, then more than a million rows of tickets and then apply M filtering (and a series of filters at that) to achieve the results I want.
And this is oversimplifying the issues. Sometimes my queries will contain joins, subqueries, CASE statements and aggregates that can be processed server-side for ease of implementation, only sending the data I really need for PowerBI.
I will add this to the idea.
