Hi Sachin, glad that you appreciated our content! If you haven't yet, you can subscribe to our channel to see all our upcoming Power BI and Power Platform video tutorials and announcements. Cheers!

Hi @rafalg8575, we’re glad that you appreciated our content! We agree, it's puzzling how major companies often struggle with data organization, especially when effective organization is crucial to breaking down silos and fostering collaboration. Finding better solutions could lead to significant improvements in their overall efficiency and communication.

Hello Wassam Masood, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Moving it to the Dataflows does make refresh faster but then it also depends further upto what extent that dedicated capacity is. If it's under the Premium capacity then refresh will be much quicker in comparison to the Pro license. But then you'll still have to check the performance by using both the options in order to make informed decisions. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! You can subscribe to our KZfaq channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

Hi K KAVYA, Thank You for posting your query onto our channel. We really appreciate you taking your valuable time to post it. In Power BI Desktop, go to the Model view and click on "Manage Relationships" and in Power BI Service, click on 3 dots available against the name of the dataset and then click onto the option of "View Lineage" and you'll be able to see the nodes. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! If you haven't yet, you can subscribe to our KZfaq channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/

Hello Avil Pinto, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. Below are the answers provided to both of your queries - 1). Dataflows can be used by Power BI Pro, Premium and Premium Per User license holders. But there're certain features which are available only to the Premium users. Below is the link of the Microsoft documentation provided for the reference. 2). Users with Premium license can only set-up Incremental Refresh inside Dataflows. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! You can subscribe to our KZfaq channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-create learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-premium-features?tabs=gen2

Hello krishnakishore peddisetti, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. The dataflow is a transformational or data cleaning process carried out in an Power Query Editor Online. Dataflow is not equivalent to a dataset. Here's the difference between the two - Dataflow - Dataflow is the data transformation component of Power BI, which is independent of any other Power BI artifacts. It is a power query process that runs in the cloud and stores the data in Azure Data Lake storage or Dataverse. Dataflow is run by Power Query engine and Power Query Editor Online. If you are consistently re-using same tables in multiple files, dataflow is highly recommended in such scenarios that means dataflow will provide you a re-usable ETL (Extract-Transform-Load) component. Dataset - Power BI datasets are considered as a source of data what we used for reporting and visualization. Datasets are the object that contains the connection to the data source, data tables, the relationship between tables, DAX calculations and the data itself. Power BI Dataset also enable us to establish connection to published report, and create your own report based on published dataset. All tables and columns can be viewed in data tab of Power BI Desktop and the entire dataset is displayed in Power BI Service under ‘My Workspace’. So, anything somehow related to the data is a part of the dataset. We're providing couple of links below on Microsoft documentation pertaining to these topics for your reference purposes. Please go through those links for your better understanding between the two concepts. For furthermore queries, you can also reach out to us onto our Community Forum by providing a proper description of the query along with the reference mock-up files to work on, where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! If you haven't yet, you can subscribe to our KZfaq channel so that you won't miss out on any Power BI & Power Platform updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/ learn.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service learn.microsoft.com/en-us/power-bi/fundamentals/service-basic-concepts learn.microsoft.com/en-us/power-bi/connect-data/service-datasets-understand

Exactly what I am thinking. Why not just have a data warehouse? Wouldn’t that give the organization more flexibility as you are not getting more deeply entangled in the Microsoft ecosystem.

Hello @nishantkumar9570, We're providing a link of the video below pertaining to this topic. For further queries, you can also reach out to us at our Community Forum by providing a detailed description of your query along with relevant files for reference. Our members and team of Experts will be happy to help out! If you haven't yet, do subscribe to our KZfaq channel and LinkedIn group to keep posted on the latest data skills and tools updates. Hoping you find this useful! Cheers, Enterprise DNA kzfaq.info/get/bejne/o9qVmK6Bs62tlIE.html forum.enterprisedna.co/ www.youtube.com/@EnterpriseDNA www.linkedin.com/groups/12004506/

@@EnterpriseDNA Thank You so much, That was really helpful.

I would still go a dataflow over a mapping file on a SharePoint if this would mean the whole department would use the same data. Datamarts are a step further, as it would imply a whole data model, but keep in mind this is premium only and computation power will be paid separately.

Hello VoiceofNEil, Thank you for posting your query onto our channel. We really appreciate you taking your valuable time to post it. We haven't explored that path yet and thank you for posting your suggestion into our comments section. We'll try and explore that option and will create a content in future. For furthermore queries, you can also reach out to us onto our Community Forum where our members as well as experts team will be able to assist you in a better and efficient manner. Below is the link of the forum provided for the reference as well. Hoping you find this useful! You can subscribe to our KZfaq channel so that you won't miss out on any Power BI updates. You can also join our LinkedIn group to receive latest updates on Power BI. Cheers, Enterprise DNA forum.enterprisedna.co/ kzfaq.info/love/y2rBgj4M1tzK-urTZ28zcA www.linkedin.com/groups/12004506/