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...
For the combined key try to use this direct query column function.
https://docs.microsoft.com/en-us/dax/combinevalues-function-dax
Avoid bi-directional joins. Refer this link
https://docs.microsoft.com/en-us/power-bi/guidance/power-bi-optimization
https://www.youtube.com/watch?v=4kVw0eaz5Ws