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
     
Johann_32's avatar
Johann_32
Advocate II
5 years ago

Hello Denis,

 

thanks a lot for the quick response. 

 

I agree to load whole data into the dataflow and limiting then in Power BI Desktop, depending on the needs of the user.

 

Still I hope what we try to do as IT, providing dataflows for our Power BI users, makes sense.

Or, if we are taking too much governance and responsibility here on IT side, which makes the tool no longer "self-service".

 

I haven't seen this approach in any governance whitepaper or in any community discussion. In general we would like to avoid users to consume non-standardized data which they later on compare with our data warehouse enterprise reporting solution.

 

 

Thank you