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 👇👇👇
@MrUmbeijo
Жыл бұрын
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.
@BILingualAnalytics
Жыл бұрын
Yes it could cause some headaches… Especially if those are slow queries and you just wait, wait and wait thinking something is broken :)
@davidpetroczy1603
Жыл бұрын
Great video, Roland! I am really happy you've made this discovery public. :) Oh by the way, this is me, David
@rolandszirmai3922
Жыл бұрын
It was great to have such a great discussion about Power BI / Power Query - that’s why I love the community!!!
Пікірлер: 5