Forum Discussion
Only use current query result
Hello,
I have 3 query
I am using these query for web scraping
These query is a massive data
It is almost an hour to get the data only for finishing 1 query
And all those 3 query already done
And now i need these 3 query result so i do append (i want to use dax formula in one table)
Unfortunately the query is starting from the beginning (connect to the website and start from zero)
How to just append the data from the result and dont have to connect to the website (internet)
Is it possible?
Any suggestions?
Thank you
3 Replies
Hi simp,
>>How to just append the data from the result and dont have to connect to the website (internet)
Is it possible?
According to your description, you want to only work on the query result, right?
If this is a case, perhaps you can try to disable the refresh option of the query which spend too much time, then regularly refresh it manually.
Notice: if you disable the refresh option of a query, it will be a temp table with cache data.
Regards,
Xiaoxin Sheng
Hi,
Here is my try:
1. Append Queries as New
2. Disable "Include in report refresh"
3. Close & Apply
And here is what happen:
"Evaluating..." and then "Waiting for the website" and my cpu will works at 100%!
Would you please elaborate about "disable the refresh option of the query"
Thank you
Hi simp,
>>Would you please elaborate about "disable the refresh option of the query"
It means the "Include in report refresh" option.
You only need to uncheck this option, then you return to report view, click refresh button, this query will cancel the refresh.I don't know why it not works on your side.
Regards,
Xiaoxin Sheng
