Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
This is called linked entities.
It is simple to do, but requires premium license:
Did I answer your question? Mark my post as a solution! Proud to be a Super User!
Connect with me!
Stay up to date on
Read my blogs on
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.