why not use DirectQuery?

[Anonymous]

Hi experts,

I see some people created massive datasets like:

After checking the content, I can see the dataset is just a select * from a View  in SQL SERVER.

Why don't they  just use DirectQuery??, so all the data doesnt have to be stored in a power bi dataset?

Is there a valid reason/case where you can't use DirectQuery? and are forced to store all of it in PowerBI?

[Idrissshatila]

Hello @Anonymous ,

There are also some limitations of using direct query, check it here 

https://learn.microsoft.com/en-us/power-bi/connect-data/desktop-directquery-about

If I answered your question, please mark my post as solution, Appreciate your Kudos 👍

Follow me on Linkedin
Vote for my Community Mobile App Idea 💡

[mlsx4]

Hi @Anonymous 

Maybe they just want faster performance, they need advanced modeling/ transformation or flexibility in terms of creating data models with higher complexity.