What is Power BI Dataflow and Why you should use it

Рет қаралды 34,878

Күн бұрын

Dataflows are an important component in the Power BI architecture. Using them can enhance the development and maintenance of your Power BI solution significantly. However, there are many Power BI implementations that are not using this functionality, even though it is already more than three years passed since it was released. In this blog and video, you will learn what is dataflow and why you should use it.
Read my blog article about it to learn more:
radacad.com/what-are-the-use-...
*******************
Want to learn about Power BI or AI? or take your Power BI and AI knowledge to the next level for building reports? Check out our courses in RADACAD Academy for all aspects of Power BI and AI.
RADACAD courses: radacad.academy
Our upcoming courses: learn.radacad.com/events/
Free books and tools for Power BI: radacad.com
Power BI Helper: powerbihelper.org/
Become an academy member: learn.radacad.com/academy/
*******************
********
CONNECT with US!
********
-- / radacad_com
-- / rad_reza
-- / leila_etaati
-- / radacad
-- / leila-etaati-b0304636
-- / rezarad
-- / 6393399
-- radacad.com
********
#PowerBI #PowerBIfromRookieToRockStar #PowerQuery #DAX #Visualization #RADACAD

Пікірлер: 28

@reportingmitpowerbi 4 ай бұрын

Great Job,thank you from Europe 👍🏻

@tinalines1426 Жыл бұрын

Great video, thank you. I have a question on Dataflows though. I am aware that connecting to an Excel File in Power Query does not allow for scheduled refresh in Power BI Service. If you connect to Excel files in a Dataflow, would this allow for scheduled refresh of those excel files?

@kummithavenkatareddy2302 Жыл бұрын

Excellent video Sir, thank you sir for you efforts. I've been following your videos since 2022. I just want to learn power query lessons from beginning from you to become PRO.. Pls Help me

@RADACAD Жыл бұрын

Thanks for your nice words. All the best in your journey

@jpg6832 Жыл бұрын

As you suggested in several of your videos, in order to try and understand the concept and idea, I have seen them over and over! I am so glad I did! Mi question, the only way I seem to be able to use dataflow with excel is with OneDrive. I do have a corporate account, is it safe?

@RADACAD Жыл бұрын

You need to have a Power BI or Power Apps account to be able to create dataflows

@user-re5uv2mm2h 11 ай бұрын

Just a clarification, if you already refresh the dataflow, the dashboard that connects to it still needs to be refreshed, but will now be faster right?

@ShubhaVilasGovindaDas Жыл бұрын

Will using data flow reduce the size of pbix file ? If we migrate the data source from direct sql to data flows

@analyticswithadam 4 ай бұрын

Thanks for the video, learned a lot

@zuah04881 Жыл бұрын

Hi there, My company is already adopting a centralised operational Dataset ( star schema approach) allowing users across department to build a Power BI report on top of the dataset. Having said that , the operational dataset is not fully matured yet and the team is working on getting the data from different departments. One of the request received from business is to use a date dimension table from the operational dataset and bring it into their model rather than creating one. What would be a feasible solution - create a dataflow to bring date dimension table or ask them to connect to the ops dataset and use already existed date table, but then this will bring out unnecessary table into their table.

@wongsakornpholjan1064 Жыл бұрын

awesome Thank you for sharing the knowledge I just got that problem like your example my data set is very very big ( .pbix file ~1.6 GB and increase every day)

@RADACAD Жыл бұрын

Thanks :) I suggest add incremental refresh to your implementation soon (if the data source supports query folding)

@ColorfulData 2 ай бұрын

Great Thanks!

@RADACAD 2 ай бұрын

You're welcome!

@spoiltbrat55 9 ай бұрын

even if you create all the transformations in data flow, we need to still apply joins in power bi desktop is it?

@RonakPatel145 4 ай бұрын

do this have limitation of data size in dataflow? if yes then what is the size limitation based on license?

@Karenshow 5 ай бұрын

Once the dataflow is created, can we go to azure and access the data from there? Thanks

@easypowerbi6963 Жыл бұрын

Very nice

@RADACAD Жыл бұрын

Thanks

@tiago5a 7 ай бұрын

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

@abhishekawari919 6 ай бұрын

Hi i have created the dataflow but while importing into the powerbi desktop im getting blank/empty table value do you know why?

@MT-oy2uk Жыл бұрын

Does dataflows generate any additional cost to your pro or ppu licence?

@RADACAD Жыл бұрын

No. with Pro license you can use some of the functionalities in the dataflow, and with Premium you can use all. but no additional cost.

@MT-oy2uk Жыл бұрын

@@RADACAD thank you very much! What about new datamart feature? Does that brings additional cost to pro or ppu? Or it is still unknown since its preview feature.

@lindabond9307 Жыл бұрын

Hmmm - I think this requires a PBI Premium license? I'm on PBI Pro and I don't have the same configuration in PBI Service as the video. I only have a Data Hub.

@RADACAD Жыл бұрын

With Pro, you can use the dataflow. By getting Data Power Platform in the Power BI Desktop, you should be able to see the Dataflow. With Premium, you will have some additional features in Dataflow, but Premium is not mandatory for dataflow.

@alirezakhalili749 Жыл бұрын

Dear Reza, I am currently in Iran and am really passionate to be an expert in PowerBI. Unfortunately, I can not work with Dataflow because as you said it is typically on the cloud. May I have your solution in this matter? is there any solution to practice with? I would really appreciate you if you lend me a hand here.