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...
Hi MattAllington,
I'm using direct query mode to upload the schema, not the data, of one table which contains all my info. In my DB, it can be considered as a giant fact table with no other tables to be put in relation with in my pbix.
Consider this, I didn't specifically make this table, but I know it's a left join between two tables.
And yes, it's taking a long time for those visuals to display in my report.
If you are using direct query mode, then query performance is managed by the source DB, not Power BI. You will need to have a dba anaylse the queries being sent to the DB and optimise the DB to support the queries.