Did you know that the Include in Report Refresh button works this way? Do you another example where you exclude queries from your report refresh? Let us know here 👇👇👇
Hi Roland, I use this feature for static (or lookup) tables where there is no need to refresh. As you demonstrated, when you refresh such a table in PQ, it will be refreshed of course (it is kind of forced refresh) but when you refresh a report from Power BI or via scheduled refresh, such tables won't be refreshed and remain the old data. Once I forgot I disabled this feature and it played a nasty trick on me when I couldn't feagure out why my report doesn't show new data while I know the new data is there and should be pulled through to a report.
Did you know that the Include in Report Refresh button works this way? Do you another example where you exclude queries from your report refresh? Let us know here 👇👇👇
Great video, Roland! I am really happy you've made this discovery public. :) Oh by the way, this is me, David
It was great to have such a great discussion about Power BI / Power Query - that’s why I love the community!!!
Hi Roland, I use this feature for static (or lookup) tables where there is no need to refresh. As you demonstrated, when you refresh such a table in PQ, it will be refreshed of course (it is kind of forced refresh) but when you refresh a report from Power BI or via scheduled refresh, such tables won't be refreshed and remain the old data. Once I forgot I disabled this feature and it played a nasty trick on me when I couldn't feagure out why my report doesn't show new data while I know the new data is there and should be pulled through to a report.
Yes it could cause some headaches… Especially if those are slow queries and you just wait, wait and wait thinking something is broken :)