Forum Discussion

Tengmin123's avatar
Tengmin123
Frequent Visitor
5 years ago
Solved

query cassandra database in report builder

DavisBI    Hi,  I'm using report builder to generate a report and my data source is cassandra database in shared data source in pbi report server.   At first, when I create a data set, my query ...
report builder
  • v-janeyg-msft's avatar
    v-janeyg-msft
    5 years ago

    Hi, Tengmin123 

     

    I see that you use format in the query. If the data type is originally date, this step is not necessary. Secondly, I see that you want to filter the data over a period of time, so this is already the simplest query, if the time is still long, it should be due to the relatively large amount of data.

     

    Best Regards

    Janey Guo

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

v-janeyg-msft's avatar
v-janeyg-msft
Icon for Community Support rankCommunity Support
5 years ago

Hi, Tengmin123 

 

I see that you use format in the query. If the data type is originally date, this step is not necessary. Secondly, I see that you want to filter the data over a period of time, so this is already the simplest query, if the time is still long, it should be due to the relatively large amount of data.

 

Best Regards

Janey Guo

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.