Forum Discussion
Post PatronPower Query Preview (Auto-Sorting?!?!)
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.)
Hi all,
We are also seeing the same behaviour with the Denodo Connector with Power BI. We have a Denodo Virtualisation over a SQL Server. When I connect to a large table via Denodo it wants to sort the preview / sample data with the primary key. When I go direct to the SQLServer I notice this is not the behaviour. So one solution for us was to remove the Primary Key meta data from Denodo and bang!! it works. So its Power BI behaviour with certain data sources...
Have been looking for a solution everywhere ... nothing.
Let me know if someone has a solution to modify this behaviour in Power BI... crazy, several billion rows in a table in Direct Query mode and it wants to sort by the primary key before giving me the first 200 rows ????
Nick