Conditional/pass query refresh

[daniel_ricardo]

I'd like to know if is there a way to pass a query refresh depending on a variable. For example, not to try to read a table depending on day and keep data of a before query.

[Daryl-Lynch-Bzy]

@daniel_ricardo - Do you have Premium capacity?  If so...

there is an option in Power BI that excludes a Table for the normal refresh (don't uncheck "Enable Load").  The excluded table can be refreshed manually using an "XLMA" API call.  This API will require Premium capacity.

[daniel_ricardo]

..but nothing that can be used in query layer, using m language?

[Daryl-Lynch-Bzy · Accepted solution]

Sorry, I don't think so.  Is the table the result of a complex calculation (i.e. takes hours to run), but you can persistent in temp table (i.e. run without the complexity).  This will just turn the refresh into a simple read task.  It could run faster, but this solution is still outside the M query language.

[daniel_ricardo]

I'll try to find some alternative to skip that, maybe using an approach as you suggested. Thanks a lot for your help!

[Daryl-Lynch-Bzy]

Hi @daniel_ricardo - could you please provide a bit more information of what you are trying to achieve?

[daniel_ricardo]

Sure! Part of our data comes form a table that is updated once a month, it is not too big but still high-cost to load every day from source. I was looking for a way to ignore this query in a range os days. Thanks in advance your your help.