Forum Discussion
Using Direct Query my pbix is extremely slow
Hello, I'm using Direct Query import mode to connect my dashboard to Oracle SQL DB. I don't have any problem when I launch queries directly on my DB in the sql Editor. The queries work well...
What the MVPs fail to mention is that Microsofts connector for Oracle is quite frankly speaking, garbage. The default vaules, which are not configurable by the user when using this connector, are the main source of this pain.
If you don't mind importing your model, you can utilize extended connection string properties in combination with Ole DB to increase your througput. But this will sacrifice your ability to utilize DirectQuery.
If you don't mind importing your model, you can utilize extended connection string properties in combination with Ole DB to increase your througput. But this will sacrifice your ability to utilize DirectQuery.
Thank you, this is the problem, unfortunately... I don't see any solutions if not trying to improve dba performance
Thank you very much for your help