Hi Nag, Your video provides a clear explanation of the dataflow concept and its practical application. I truly appreciate the effort you put into creating this valuable content!
Sir could you please guide , 1. is there any capacity defined for Dataflow. Max how many tables we can add? 2. Also are we allowed to do further data transformation in the power bi desktop if we use dataflows?
Hi Nag, I was trying to follow your video to add tables into Dataflow. So far, I was successful in adding individual excel files, however I blocked when I tried to import data from a folder. Any tips you can share?
So the DB is linked to the dataflow which is in app.power bi which is inside a specific users login.. What if he leaves the organisation and some chanes need to done in the ETL? Kindly explain
For safer side , there should be alternative person should also have same access as admin to the workspace. Or before leaving the organisation he should delegate all the dependency to some other user. He should provided access to someothef user and leave.
Thanks for the video! After using the dataflow in the dataset when you build the model in the dataset is it possible to connect the table which comes from dataflow and the one which comes from excel. I have asked this question in the interview. So I just wanted to confirm. Also could you please let me know what are the drawbacks of the dataflow.
Sir.. can we replace the view which I have used from Azure database with any other workflow? My current dashboard is with azure database connection and now client have created the same view as a dataset and asking us to use that... In this case I should create a all new dashboard or is there any option to replace the data source with the dataset?.. please advise
Database you can treat as a import mode , where as dataset considered as live connection or SSAS tabular. For database power bi uses sql, for dataset power bi uses Dax to read the data from source. I hope you need to recreate the dashboard. My answer is Based on your writings above.
Just to clarify, on the Power BI desktop, if a user has a free license, can he/she use the data flow from a user of a paid account? - is that possible?
Hi Nags, after providing folder path, the connection credentials is not refreshed. I mean no drop down option shown. Let me know the specific reason, why its not loading after providing folder path. I am unable to create dataflow because of that. I appreciate if you answer for this question
Hello sir, I would like to ask if there's a difference between dataflows and Azure analysis service? I just want to know where the data model is stored eventually. Is it stored in AAS or dataflows? I asked this because I'm not sure, so I want someone to clarify me. I'm building pipeline to data model to visualization (power bi) But when it comes to modeling data before it goes to power bi service, I just not sure where the model is stored. Is it stored in aas or is it stored in dataflows (azure data Lake storage)?
Dataflows target data stored in azure data lake. This is internal to power bi. You have to design the dataflow that's it. So for your power bi report dataflow act as a another source. Watch the first few minutes of this video again and also watch the diffet between dataflows and datasets. ua-cam.com/video/D8X7aWcvkVQ/v-deo.html
@@AnalyticswithNags Thank you. So basically say for example, PowerBi has 3 things: (1)report view (2)data view (3)model view Dataflows will take care for the transformation of the data (2). While powerbi will take care of visualization(1) and modeling(3) Do I understand correctly?
@@norpriest521 data flow will not take care of the transformation by itself. Once you create dataflow on cloud it can be reused by anybody. It's a reusable cleaned or preprocessed data but data pre processing has to be done by us. It's something like this. Pre process once reuse many times
In my case, the drop down for Data Gateway does not shown any option. It shows only 'None'. And thus Next option stays grayed out. Can you please advise?
Underrated video. It deserves more likes. The response to the comments section is also very much helpful... 👏👏
Thanks for your video. Share this channel with friends and colleagues
Hi Nag,
Your video provides a clear explanation of the dataflow concept and its practical application. I truly appreciate the effort you put into creating this valuable content!
Glad it was helpful!
Good morning sir, when I see new video you updated, our journey it's starting. MSBI best channel have.
All the best
Sir could you please guide ,
1. is there any capacity defined for Dataflow. Max how many tables we can add?
2. Also are we allowed to do further data transformation in the power bi desktop if we use dataflows?
1) no limit
2) yes
thinks man great help for us.
Thanks. Keep Learning
Hi Nag,
I was trying to follow your video to add tables into Dataflow. So far, I was successful in adding individual excel files, however I blocked when I tried to import data from a folder. Any tips you can share?
Thanks for great demo and explanation.
Glad it was helpful!
hello sir, any transformation we do in dataflow doesn't affect the original data source right?
Yes. You are right
So the DB is linked to the dataflow which is in app.power bi which is inside a specific users login.. What if he leaves the organisation and some chanes need to done in the ETL? Kindly explain
For safer side , there should be alternative person should also have same access as admin to the workspace. Or before leaving the organisation he should delegate all the dependency to some other user.
He should provided access to someothef user and leave.
It is also to the point 👌
Thanks keep learning
Good Explanation
Thanks for liking
very useful
Thanks keep learning
Thanks for the video! After using the dataflow in the dataset when you build the model in the dataset is it possible to connect the table which comes from dataflow and the one which comes from excel. I have asked this question in the interview. So I just wanted to confirm. Also could you please let me know what are the drawbacks of the dataflow.
Yes you can!
@@AnalyticswithNags ok thanks for responding. Also can please let me know the draw backs of dataflow?
Sir.. can we replace the view which I have used from Azure database with any other workflow? My current dashboard is with azure database connection and now client have created the same view as a dataset and asking us to use that... In this case I should create a all new dashboard or is there any option to replace the data source with the dataset?.. please advise
Database you can treat as a import mode , where as dataset considered as live connection or SSAS tabular. For database power bi uses sql, for dataset power bi uses Dax to read the data from source. I hope you need to recreate the dashboard.
My answer is Based on your writings above.
@@AnalyticswithNags thank you sir... This helps
Just to clarify, on the Power BI desktop, if a user has a free license, can he/she use the data flow from a user of a paid account? - is that possible?
No
Hi Nags, after providing folder path, the connection credentials is not refreshed. I mean no drop down option shown. Let me know the specific reason, why its not loading after providing folder path. I am unable to create dataflow because of that. I appreciate if you answer for this question
Explore the similar problems here, learn.microsoft.com/en-us/answers/
Hello sir,
I would like to ask if there's a difference between dataflows and Azure analysis service?
I just want to know where the data model is stored eventually.
Is it stored in AAS or dataflows?
I asked this because I'm not sure, so I want someone to clarify me.
I'm building pipeline to data model to visualization (power bi)
But when it comes to modeling data before it goes to power bi service, I just not sure where the model is stored.
Is it stored in aas or is it stored in dataflows (azure data Lake storage)?
Dataflows target data stored in azure data lake. This is internal to power bi. You have to design the dataflow that's it. So for your power bi report dataflow act as a another source.
Watch the first few minutes of this video again and also watch the diffet between dataflows and datasets.
ua-cam.com/video/D8X7aWcvkVQ/v-deo.html
@@AnalyticswithNags
Thank you.
So basically say for example, PowerBi has 3 things:
(1)report view
(2)data view
(3)model view
Dataflows will take care for the transformation of the data (2).
While powerbi will take care of visualization(1) and modeling(3)
Do I understand correctly?
@@norpriest521 data flow will not take care of the transformation by itself. Once you create dataflow on cloud it can be reused by anybody. It's a reusable cleaned or preprocessed data but data pre processing has to be done by us. It's something like this. Pre process once reuse many times
@@aiinabox1260What is the difference between datasets and dataflow?
In my case, the drop down for Data Gateway does not shown any option. It shows only 'None'. And thus Next option stays grayed out. Can you please advise?
Ensure your gateway is running in your pc
Hi Sir I have a query Regarding a project I am doing , Kindly reply so that it can help me . Please
How can I help you?
@@AnalyticswithNagsHi sir , can you please help with the pbix of restaurant analytics 🥹
Want more clarification on D Flow/D Sets
Watch this video. That may clarify your points.
ua-cam.com/video/D8X7aWcvkVQ/v-deo.html
Which user name and psw I need to provide
Your organization user name and password