Forum Discussion

robarivas's avatar
robarivas
Icon for Post Patron rankPost Patron
5 years ago
Solved

Power Query Preview (Auto-Sorting?!?!)

I'm connecting (thru Power Query in Power BI) to a very large table in Oracle. The preview is not generating (fails and/or times out). Turns out its because Power Query (as part of the Navigation ste...
Need Help
  • edhans's avatar
    edhans
    5 years ago

    In the initial connection screen robarivas you can write your own SQL statement. I activily recommend against this in production as it will break 100% of all future query folding. But in this scenario, it can assist in trouble shooting.

     

    Does it do this with any table on that server, or just this one? if it just this one, it might be an insanely massive table and the driver isn't coping with it well. If that is the case, consider working with your DBA to privide a view to you to use vs the table. Then connect to the view. All transformation later that Power Query can convert to SQL statements will fold.

     

    If it is all tables though, then there is definitely a problem with the server configuration or your driver (ensure you have the latest Oracle driver for Power BI.)