Forum Discussion
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? DirectQuery or Import method? or can we have a combination of both for best performance?
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 👍
4 Replies
Hello mandarnakil ,
You could import the data because its not that huge, but make sure to work it as a star schema and just get the tables and the columns needed for creating the requirments.
https://learn.microsoft.com/en-us/power-bi/guidance/star-schema
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?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 👍
