What is Power BI Dataflow and Why you should use it
Vložit
- čas přidán 12. 07. 2024
- 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 - Věda a technologie
thanks for simplifying this!
Great Job,thank you from Europe 👍🏻
Great Thanks!
You're welcome!
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?
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
Thanks for your nice words. All the best in your journey
Will using data flow reduce the size of pbix file ?
If we migrate the data source from direct sql to data flows
Very nice
Thanks
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)
Thanks :)
I suggest add incremental refresh to your implementation soon (if the data source supports query folding)
even if you create all the transformations in data flow, we need to still apply joins in power bi desktop is it?
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?
Thanks for the video, learned a lot
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?
You need to have a Power BI or Power Apps account to be able to create dataflows
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.
do this have limitation of data size in dataflow? if yes then what is the size limitation based on license?
Once the dataflow is created, can we go to azure and access the data from there?
Thanks
Hi i have created the dataflow but while importing into the powerbi desktop im getting blank/empty table value do you know why?
Is it possible to use Python in the dataflow to transform data? Thanks
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.
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.
Does dataflows generate any additional cost to your pro or ppu licence?
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.
@@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.
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.
no se ve nada, no explicas mucho