How to use Dataflows in Power BI // Beginners Guide to Power BI in 2021
ฝัง
- เผยแพร่เมื่อ 30 พ.ค. 2021
- In this video we cover how using dataflows can help you improve the way you manage your data source connections in Power BI
-
🚩 Support us to get perks such as demo files, early access and more!
/ solutionsabroad
MY FAVOURITE POWER BI BOOKS
📕 The Definitive Guide to DAX - amzn.to/3ruYs2f
📗 DAX Patterns - amzn.to/3oVgOYs
MY GEAR
🎥 Canon 4000D DSLR Camera - amzn.to/3tCqDOw
💻 Cyberpower Wyvern PC - amzn.to/3q04QOw
🪑 Infamous Gaming Chair - amzn.to/3q3iUXw
💡 LED Studio Lighting - amzn.to/3q3ftQz
🎙 Lavalier Microphone - amzn.to/3jwKutG
📺 Monitor - amzn.to/2LuHhhO
GET IN TOUCH
📺 Website - www.solutionsabroad.co.uk
📧 Email me - fernan@solutionsabroad.co.uk
🤵 LinkedIn - / solutionsabroad
📘 Facebook - / solutionsabroad
📸 Instagram - / solutions_abroad
🐤 Twitter - / abroadsolutions
🤖 Reddit - / fernanespejo
🌍 WHO IS SOLUTIONS ABROAD
Hi, my name is Fernan, the one-man band of Solutions Abroad. I work as a Data Scientist based in London, UK and have over 6 years of experience working in Business Intelligence. Solutions Abroad these days is dedicated to teaching the ins and outs of Power BI, through the power of TH-cam.
If you want to learn more, I’ve conveniently created playlists to help you find the right topic for you.
🐎 First, watch this video about how a typical Power BI workflow looks like
• Power BI from START to...
🗺 Learn DAX to extend your Power BI calculations
• Power BI DAX Basics OLD
📆 Stay up-to-date on all the features Power BI releases monthly
• Power BI Monthly Featu...
🧪 Get certified as a Microsoft Data Analyst Associate
• Power BI DA 100 Prepar...
💡 Learn Power BI Features to improve your dashboards
• Power BI Feature Highl...
📊 WHAT IS POWER BI?
Power BI is a business analytics tool by Microsoft. It creates a working environment suited for normal users, meaning tasks such as data extraction, cleansing, analysis and storytelling; these are made easily-accessible to citizen-users, and extendable for technical users. At face value it provides visually-stunning, interactive dashboards, but it’s built on top of so much more.
🔻 Get started with Power BI Desktop for FREE
powerbi.microsoft.com/en-us/d...
#PowerBI #DataAnalytics #BusinessIntelligence
So helpful and just what I needed! Thank you
Best video on Dataflow that I have seen so far
Thank you very much for the excellent video!
Very helpful! Thank you.
Excellent explanation to connect the database through dataflow
Your videos are fantastic bro
Thanks for Help!
Thanks Fernan You do a great job breaking down complex issues to very understandable concepts. You have helped me a lot
Appreciate that Merid, thanks for watching!
@@SolutionsAbroadit's possible to create power BI report from data flow directly in power BI service not in Desktop?
Thank you. very helpful
Its good to see the ABC between the A and C. Some just does not put in context.
There are lot of Power Bi videos that does not capture this.
This is great, thanks for sharing!
Glad you enjoyed it!
Thank you so much fernan, very helpful
My pleasure!
Awesome thank you
thanks a lot!
Hello Fernan Thanks for the wonderful content.
Can we see the data inside the dataflow..I had created one from a Google Big query and using it in the Power BI dashboard and have some missing data.. so not sure if it is something missing at data flow and I am unable to see underneath
Very useful. Pls, share more videos on online Data services like Azure Data Factory and Power Bi online. :)
Hi Karthik, lots more Power BI Service videos are coming up soon, dont worry! thanks for watching!
Hi Fernan! 1. What if we’re working with big data and tables with millions of rows? Wouldn’t the refresh time out or not and if so, what is a solution? 2. Can we query for a certain time period or year, etc to minimize the initial data refresh?
I'm pretty sure you can do all transformations on desktop, publish it and then use the published dataset as a source to create a report so separate model & report, I'm not sure tho if this would create another dataset when connecting to the exsisting one and only creating report?
Super
Can you do soemthing on refresh where the data is in a flat file and needs to be modeled into a realtional database and then updated both core data and lookup tables all needing updating
As You Gave Your Credentials on the Azure Database Option I have a Question here
That in Advance option we had the option named Import and Direct Query and by default it will take Import only like in you example. If i choose Direct Query, will it work the same way ?
in your personal opinion and experience, is it good practice to DFs as a sources? In my company all the sources are from DFs....
I have created the dataflow by connecting with it Azure Databricks. However I can see the data in dataflows but Can't see anything when I load the data in Power Bi. What can be the reason. The same issue you are showing in the video when you load the data first time. Showing empty rows.
maybe you like to dive into the compute entities /linked entities and the limitations for non premium users.
Br
Interesting suggestion, I'll have a look at covering this in the future, thanks!
3:15- connecting to Azure SQL database dataflow
Hi Fernan, Is any Option to download the pbix file what you are showing in the videos?
Hi Syamala, thanks for watching! Yes of course, they're all available through my Patreon page here: www.patreon.com/posts/demo-files-52538104
Can the dataflow connect via live connection? So that I don't have to refresh the dataflow and just refresh the dataset
I believe so! However it requires a Premium license; docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-directquery
Is it possible to use Python in the dataflow to transform data? Thanks