Forum Discussion
DirectQuery vs Import
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?
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 👍
Hello Idrissshatila,
I have fact tables and dimension tables in the same data source. First, I used DirectQuery for importing Fact tables. Then I wanted to import the dimension tables from the same data source but the Import option was disabled. So I tried using the below option to convert the storage mode to Import but it is importing the fact tables too which we don't want
So I wanted to ask if we can DirectQuery as well as use Import option for the same data source? If not, is there any other way I can achieve this?