topic Re: Dataflow Gen2 Very Slow to Preview Oracle On Premises Data in Dataflow

Dataflow Gen2 Very Slow to Preview Oracle On Premises Data

kdoherty — Fri, 09 Jun 2023 12:23:22 GMT

I find that the data preview in Power Query for Dataflows Gen2 is very slow to populate when connecting to on premises Oracle database. Small tables (1000 rows) take 4+ minutes to populate preview.

Is this a common experience?

Thank you.

Kevin Doherty

Re: Dataflow Gen2 Very Slow to Preview Oracle On Premises Data

miguel — Thu, 08 Jun 2023 17:07:37 GMT

This is not the expected experience, but it also depends on a number of factors such as your network, the data source, and our service.

I'd recommend reaching out to our support team so they can do a more thorough investigation to see what could be happening and why it takes so long to query the data.

Re: Dataflow Gen2 Very Slow to Preview Oracle On Premises Data

kdoherty — Fri, 09 Jun 2023 12:24:00 GMT

Thank you. I will contact support.

Re: Dataflow Gen2 Very Slow to Preview Oracle On Premises Data

kdoherty — Fri, 09 Jun 2023 13:59:07 GMT

The issue I experienced was due to an Advance Option I had turned on in the Power Query builder.

Include Relationship Columns - this being one cause many additional columns of type Table to be added to the query. Once I turned this off, data preview is much better.

Thank you.