Forum Discussion
dataflows: Error native query onprem oracle datasource
HI csacristan - this feature is not yet avialanle in the dataflows preview. Please vote up on the existing feature suggestion if it is important to you.
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.