Forum Discussion
Conditional/pass query refresh
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.
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.
6 Replies
Hi daniel_ricardo - could you please provide a bit more information of what you are trying to achieve?
- 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.
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.
..but nothing that can be used in query layer, using m language?
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.
