How to use Dataflows in Power BI // Beginners Guide to Power BI in 2021

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

Просмотров 37 тыс.

50% 1

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 RU-vid.
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

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

30 май 2021

Ссылка:

Скачать:

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

Добавить в:

Мой плейлист

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

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

@CaponeSlays 2 года назад

So helpful and just what I needed! Thank you

@sapnaa6576 2 года назад

Best video on Dataflow that I have seen so far

@evangeliastone7374 2 года назад

Very helpful! Thank you.

@joseluisbeltramone599 11 месяцев назад

Thank you very much for the excellent video!

@tajamulkhanofficial 6 месяцев назад

Thanks for Help!

@user-iz6ju9ft6e 4 месяца назад

Thank you. very helpful

@EmediongJob-ih6xb Год назад

Your videos are fantastic bro

@bittencourt1869 Месяц назад

Excellent explanation to connect the database through dataflow

@veeek8 Год назад

Awesome thank you

@emach4392 Год назад

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.

@meridtekle6928 2 года назад

Thanks Fernan You do a great job breaking down complex issues to very understandable concepts. You have helped me a lot

@SolutionsAbroad 2 года назад

Appreciate that Merid, thanks for watching!

@AK-ij9il 6 месяцев назад

@@SolutionsAbroadit's possible to create power BI report from data flow directly in power BI service not in Desktop?

@ed2672 Год назад

thanks a lot!

@JavitoTag 2 года назад

This is great, thanks for sharing!

@SolutionsAbroad 2 года назад

Glad you enjoyed it!

@gauthama4092 2 года назад

Thank you so much fernan, very helpful

@SolutionsAbroad 2 года назад

My pleasure!

@satyasuresh9473 2 года назад

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

@evangeliastone7374 2 года назад

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?

@remek5758 2 года назад

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?

@arunsundarm4566 4 месяца назад

Super

@monmorelord6368 Год назад

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

@RetaxChennai 3 года назад

Very useful. Pls, share more videos on online Data services like Azure Data Factory and Power Bi online. :)

@SolutionsAbroad 3 года назад

Hi Karthik, lots more Power BI Service videos are coming up soon, dont worry! thanks for watching!

@mirrrvelll5164 Год назад

in your personal opinion and experience, is it good practice to DFs as a sources? In my company all the sources are from DFs....

@eagillum 2 года назад

3:15- connecting to Azure SQL database dataflow

@fardeenahmedkhan517 Месяц назад

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 ?

@tiago5a 8 месяцев назад

Is it possible to use Python in the dataflow to transform data? Thanks

@syamalabrahmareddy6418 2 года назад

Hi Fernan, Is any Option to download the pbix file what you are showing in the videos?

@SolutionsAbroad 2 года назад

Hi Syamala, thanks for watching! Yes of course, they're all available through my Patreon page here: www.patreon.com/posts/demo-files-52538104

@hrishitathe1947 2 месяца назад

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.