Only use current query result

[simp]

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

[v-shex-msft]

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

[simp]

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

[v-shex-msft]

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