Forum Discussion
Solved
DirectQuery vs Import
I am using Oracle Database. There are 10-15 tables having a million of records in total. I have to create 30-40 dashboards using this data. Which one would be the better option performance wise? Dire...
Hello mandarnakil ,
In this case, it's better to import the dimension tables and the fact table that has the billion record usr the direct query modeling.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Oh, thanks Idrissshatila for the answer!
Actually, I came to know that the data that I will be working on, might increase further and it might be a billion of records in future, not millions. So what would be the best approach in that scenario?
Idrissshatila
Super User
Super UserHello mandarnakil ,
In this case, it's better to import the dimension tables and the fact table that has the billion record usr the direct query modeling.
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍