Forum Discussion

kasiaw29's avatar
kasiaw29
Resolver II
5 years ago
Solved

No data in report when using direct query

Hi all,   Having a rather strange problem. Normally I use import query option for data but this time I'm going in direct as I need to display information on TVs so need is as close to real time as ...
Need Help
  • MFelix's avatar
    MFelix
    5 years ago

    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.

     

     

kasiaw29's avatar
kasiaw29
Resolver II
5 years ago

Thank for reply, it looks like for what I need it I'm probably best switching to import mode. 

 

Thanks again! 

MFelix's avatar
MFelix
Super User
5 years ago

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.