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.
Hello
I'm having difficulties setting up an incremental refresh in Power BI.
I've set up the two parameters as described
The column that I'm trying to use as a incremental is defined as date/time
However, when I try to specify the parameter, it doesn't seem to let me use the parameters
i'm following the steps from this link
https://docs.microsoft.com/en-us/power-bi/service-premium-incremental-refresh
what am i doing wrong?
Solved! Go to Solution.
You have to change the filter to not ask for dates, but for parameters.
Pretty sure you can also put in any date, then change the formula bar and remove the date and replace with your parameter.
Table.SelectRows(#"Added Workday", each [Date] = #date(2019,1,1)
would become
Table.SelectRows(#"Added Workday", each [Date] = test)
Where "test" is the test parameter I set up.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingYou have to change the filter to not ask for dates, but for parameters.
Pretty sure you can also put in any date, then change the formula bar and remove the date and replace with your parameter.
Table.SelectRows(#"Added Workday", each [Date] = #date(2019,1,1)
would become
Table.SelectRows(#"Added Workday", each [Date] = test)
Where "test" is the test parameter I set up.
DAX is for Analysis. Power Query is for Data Modeling
Proud to be a Super User!
MCSA: BI ReportingThat was it!
I changed it to parameter and it works!
Thanks!
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.
User | Count |
---|---|
106 | |
94 | |
77 | |
65 | |
53 |
User | Count |
---|---|
145 | |
105 | |
104 | |
90 | |
63 |