Forum Discussion
Most efficient query method when source is URL with static date range
Hello,
I may have answered my own question with some additional research. Because my only source for data is url based, my primary concern was that the query would take too much time. The data imported has close to 100 columns and several thousand rows. I didn't want to stress whatever service was creating the data, hence the path i took was to make paramters. For the two date fields in the url i shared, my intent was to bind those to paramters in my report thus allowing the date range to be modified in the URL. Turns out that only works with direct query.
It seems the only way i can make this work is to periodically adjust paramters so the url is not trying to return too much data.
Hi kahuna965 ,
I'm a little confused about your needs, Could you please explain them further?
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
Hello,
I may have answered my own question with some additional research. Because my only source for data is url based, my primary concern was that the query would take too much time. The data imported has close to 100 columns and several thousand rows. I didn't want to stress whatever service was creating the data, hence the path i took was to make paramters. For the two date fields in the url i shared, my intent was to bind those to paramters in my report thus allowing the date range to be modified in the URL. Turns out that only works with direct query.
It seems the only way i can make this work is to periodically adjust paramters so the url is not trying to return too much data.