Forum Discussion
why not use DirectQuery?
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?
2 Replies
Hi Anonymous
Maybe they just want faster performance, they need advanced modeling/ transformation or flexibility in terms of creating data models with higher complexity.
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 💡
