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
     
selimovd's avatar
selimovd
Most Valuable Professional
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
 
elliottriley's avatar
elliottriley
Frequent Visitor
4 years ago

Hi selimovd 

 

Hope you don't mind me jumping on this question, but you mention "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."  That would be what we would want to do, but I can't see anywhere how towrite the syntax to use a parameter within power query using a dataflow as a data source?  Is this still possible?

 

Thanks,

Elliott