Finding the Best Power BI Data Connector - CSV files 🤔
I believe most Power BI report creators started building or are going to build reports with “Get Data from Excel”; using either a local file or a folder on a network drive.
However, the real question is which file type should we use? I never really thought about this question before, but luckily I started exploring the differences between XLSX and CSV import.
In this video, I share with you the refresh speed differences!
Have a good one,
Roland
💪 New videos coming every Tuesday 🤹♂
📝BLOG POST: https://bilingualanalytics.com.au/dat...
🎬 Previous Videos:
Finding the Best Power BI Data Connector - DataFlow 👑 - • Finding the Best Power BI Data Connec...
Finding the Best Power BI Data Connector - SQL Database - • Finding the Best Power BI Data Connec...
Finding the Best Power BI Data Connector - OneDrive ⛅ - • Finding the Best Power BI Data Connec...
🔗 LINK:
Phil Seamark's blog: https://dax.tips/2021/02/15/visualise...
Chris Webb's blog: https://blog.crossjoin.co.uk/2018/08/...
Chapters:
00:00 Intro
00:22 Data Connector Series
00:42 Topic Of The Day
01:24 How To Reach Out
01:49 How To Measure
02:28 Starting Point - XLSX
03:40 Baseline Wrap-Up
04:01 Convert XLSX to CSV
05:15 CSV Import Report
06:04 Wrap-Up
06:24 But Why???
07:00 Question Of The Day
07:20 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:
📷 – Canon EOS 200D
🎙 – Audio Technica AT2020
🔦 – Neewer 18” Ring Light
🎧 – BOSE QC35
🖥 – 2x ASUS VC279H
💻 – AMD Ryzen 3600, Gigabyte X570, GTX1650, G.Skill 32GB RAM
Music: www.bensound.com
#Excel #PowerBI #BILingualAnalytics #CSV #XLSX #Data #ReportRefresh