Consume dataflows – Part 3


In previous part, We created and configure dataflows. If you miss the previous part then here is the link

In this article, We will see how to consume dataflows.

A dataflow can be consumed in the following three ways:

  1. Create a linked entity from the dataflow to allow another dataflow author to use the data
  2. Create a dataset from the dataflow to allow a user to utilize the data to create reports
  3. Create a connection from external tools that can read from the CDM format

In this article, We will cover point 2. Create a dataset from the dataflow to allow a user to utilize the data to create reports

To consume a dataflow, run Power BI Desktop and select the Power BI dataflows connector in the Get Data dialog.

Login with Organization account.

Select Demo dataflow and Select all entities.

Here, We will show the information  about employee, position and department. Also we will create some headcount of employees, department, Positions and FTE.

Once it is ready then report should like below.

Licensing

Dataflows best practices

It can be found here for detailed explanation

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-best-practices

Dataflows limitations

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-features-limitations

Reference link :

https://docs.microsoft.com/en-us/power-bi/transform-model/dataflows/dataflows-introduction-self-service

https://radacad.com/what-are-the-use-cases-of-dataflow-for-you-in-power-bi

If you like this article, feel free to share it with others who might find it helpful! If you have any questions, feel free to reach out to me.

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out /  Change )

Twitter picture

You are commenting using your Twitter account. Log Out /  Change )

Facebook photo

You are commenting using your Facebook account. Log Out /  Change )

Connecting to %s

Create a website or blog at WordPress.com

Up ↑

%d bloggers like this: