Fetching Data from dataflow

[Anonymous]

Hi All, I would like to create a new dataflow and use an already existing dataflow as data source (I need some selected entities from that dataflow). But that dataflow has huge volumes of data due to which merging and filtering data once tables are loaded is very time consuming. So I would like to add a filter like date filter at the time of fetching an entity from that dataflow. It is very easy to do when your data source is SQL, you can simply write the sql query and add the filter there before importing. But how can I do that using dataflow as data source? 

Thanks in advance,

[SteveCampbell]

This is called linked entities.

It is simple to do, but requires premium license:

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

[mahimabedi]

A linked entity cannot be modified. So for this usecase, you will not be able to add a filter on top of the original dataflow.

If you are ok with creating the new entity within the same dataflow. You can create a "computed entity" in which you can apply a filter. This is similar to how we refer tables instead of recreating. 

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