How To Use Include in Report Refresh in Power Query | Power BI Data Settings

Подписаться 7 тыс.

Просмотров 1,6 тыс.

50% 1

From this Power BI tutorial, you will learn the two distinct behaviors of the Include in Report Refresh button in Power Query.
I reckon it's a bit hard to draw the line where the report refresh process starts and stops, so I was happy that my friend David asked this question.
I can tell you that it was also a new learning for me as I have never tried to "connect" a query that I excluded from report refresh in Power Query inside of Power Query :)
I guess that's one of the many reasons why it's great to have such a lively community, right?
I hope you enjoy this one!
Have a good one,
Roland
💪 New videos coming every week 🤹‍♂‍
🤘 New short videos coming every week 👨‍🏫
🎬 MORE VIDEOS:
Power BI & Power Automate - How to automate reporting process -
• Power BI & Power Autom...
Power BI Row-level Security - Complete Guide - • Power BI Row-level Sec...
Dynamic Row-level Security 🔐 - Based on Dimension Tables - • Dynamic Row-level Secu...
Chapters:
00:00 Topic Of The Day - Include In Report Refresh
00:43 Intro
00:54 BI-Lingual Analytics
01:12 Data Setup
01:28 Queries in Power Query
02:20 Scenario 1 - Expected Result
03:30 Scenario 2 - Different Result
05:42 How To Use Include in Report Refresh
06:07 Use Case For Both Scenarios
06:30 Questions? Comments?
06:47 End
▼▼▼▼▼▼▼▼▼
Make sure to hit the 👍 button and ❗❗ SUBSCRIBE ❗❗ to my channel.
If you have any questions, just let me know either in the comments down below 👇 or send us an e-mail 📩.
▲▲▲▲▲▲▲▲▲
🤝 HOW TO CONNECT 🤝
LinkedIn - / bilingualanalytics
Twitter - / bilanalytics
Subscribe - / @bilingualanalytics
ABOUT ME: bilingualanalytics.com.au/abo...
📍 - Sydney, Australia
📽 GEAR:
📷 - Sony ZV-E10
🎙 - Audio Technica AT2020
🔦 - Neewer 18” Ring Light, Elgato Key Light
🎧 - BOSE QC35
🖥 - ASUS VC279H + Xiaomi Mi Curved 34"
💻 - Intel i7-12700K, Gigabyte Aorus Master 3080 12GB, Corsair Vengeance LPX 64GB, Samsung 980Pro 1TB
#PowerBI #PowerQuery #PowerBIPro

Наука

Опубликовано:

6 авг 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 5

@BILingualAnalytics Год назад

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 👇👇👇

@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!!!

@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 :)