Forum Discussion
No data in report when using direct query
There are advantages and disavantadges in both scenarios, depend what what you need to do, when the dataset is huge for sure best option is the directquery because of refresh times, but you then have performance issues on the refresh of the vizualizations.
It may seem a strange advice but in some cases is a trial and error approach of checking logs and verify what are the best results.
Hi kasiaw29 ,
When using the Direct Query you do nont have access to the change the data settings, that is why the data is not present altough you can see it in the query editor if you try to make some change adding an additional step immeditaly the model asks you to change to import mode.
Basically you can only change the information by adding measure.
Altough I don't understand why there is no data presented in the model view, I believe it's because of size limitations because if you connect to a database is terabite of rows presenting the full information would freeze, in the query editor it's only a part of the model 1000 rows or similar so it presents the data.
Check the post below about advantages and disavantages
https://docs.microsoft.com/en-us/power-bi/connect-data/desktop-use-directquery
Thank for reply, it looks like for what I need it I'm probably best switching to import mode.
Thanks again!
There are advantages and disavantadges in both scenarios, depend what what you need to do, when the dataset is huge for sure best option is the directquery because of refresh times, but you then have performance issues on the refresh of the vizualizations.
It may seem a strange advice but in some cases is a trial and error approach of checking logs and verify what are the best results.