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 and super fast.
The problem is that my pbix is extremely slow. I thought it was the high amount of rows uploaded (16 million), but things didn't change after I have uploaded 355 rows using a where condition from my DB. In both scenarios, my pbix is VERY VERY slow. I'm talking about 1-2 minutes to upload a slicer and 3-minutes to upload a line chart.
I don't think it's normal.
I thought the issue could be because I used a concatenation of fields to create my table key to be used in my pbix in the direct query.
In direct query I did something like this:
SELECT field_1 || '_' || field_2 || '_' || field_3 as table_key
field_4,
field_5,
field_6,
FROM table
(I thought it could be the || operator, but it gives me the same problem when I use CONCAT)
I read somewhere that fields concatenation can be an issue when in direct query mode.
Do you guys have any idea?
Thank you
