Forum Discussion

Johann_32's avatar
Johann_32
Advocate II
5 years ago
Solved

Parameters in Dataflows

Hello,   we are in the start up phase of Power BI in our company and plan to provide standardized Dataflows to our Power BI users, coming from IT side. This is a key part of our governance strategy...
Dataflow
  • selimovd's avatar
    selimovd
    5 years ago

    Hey Johann_32 ,

     

    a data flow is usually refreshed a few times a day. After that refresh the data is saved in Azure Datalake Gen 2 and when you connect to the data flow the data is taken from the data lake.

    So if you load 2 years in the refresh, then the data flow contains 2 years. When you connect with Power BI you connect to the refreshed data in the data lake.

     

    I personally would load the whole data to the data flow, then you can still limit it in the Power BI report with a parameter.  Would that work for you?

     

    If you need any help please let me know.
    If I answered your question I would be happy if you could mark my post as a solution ✔️ and give it a thumbs up 👍
     
    Best regards
    Denis