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

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 Automate - How to au...  

Power BI Row-level Security - Complete Guide -    • Power BI Row-level Security - Complet...  

Dynamic Row-level Security 🔐 - Based on Dimension Tables -    • Dynamic Row-level Security 🔐 - Based ...  

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: https://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