Forum Discussion
Using Direct Query my pbix is extremely slow
It would help if you could clarify a few things, as it seems you may be confusing a few concepts. There are 2 modes for power BI. Direct Query and Import Mode. If you are using direct query, the data is not loaded into power BI tables - all queries are sent to the source DB. If you are loading data into power BI, then it is import mode.
You then say you are uploading slicers and line charts. What do you mean? Are you saying it is taking a long time for those visuals to display in your report?
You say your report is very slow. What is your database design (assuming import mode)? Have you built a star schema following dimensional modeling principles? Or have you just imported your Oracle DB?
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.