Power BI Dataflow - Access On-Premise Data Using a Gateway
In this tutorial I show you how to access on-premise Excel files and Folders in Power BI Dataflow using a Data Gateway.
It is a relatively simple process and it allows you to go beyond cloud-based data sources or connectors in Dataflow.
I reckon it is a must for many Analyst, as not all data can be published to OneDrive or other cloud based source.
If you find this useful, don't forget to hit those button under the video!
Have a good one,
Roland
💪 New videos coming every Tuesday 🤹♂
📝 BLOG POST: https://bilingualanalytics.com.au/dat...
🎬 MORE VIDEOS:
TOP 5 Power BI Tips To Get Started in 2022 📊 - • TOP 5 Power BI Tips To Get Started in...
Power BI & Power Automate - How to automate reporting process - • Power BI & Power Automate - How to au...
Dynamic Time Period Comparison With Power BI - • Dynamic Time Period Comparison With P...
Chapters:
00:00 Intro
00:18 Topic Of The Day
00:30 DataFlow 101
00:40 Data Source Location
01:22 Understanding The Problem
02:23 Download And Setup Data Gateway
04:02 What's Next?
04:22 Add Data Source To The Gateway
05:53 Create Dataflow Using The Gateway
07:10 Add Gateway Data Source From Dataflow
08:10 Refresh Dataflow
08:29 Benefits Of Using a Data Gateway and Dataflow
09:19 Before You Install Gateway
09:36 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"
💻 – AMD Ryzen 5900, NZXT N7, RTX 3060 Ti, Team T-Force ARGB 64GB RAM
Music: www.bensound.com
#PowerBI #DataFlow #On-PremData #BILingualAnalytics