Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
There is a list MaxDate (2) (which is basically a table with one cell that calculates yesterday's date, which is converted into a list in order to be referred by the parameter as a query)
The parameter which i need to update automatically is referring to the above list
But as you see above, the current value is 13/02/2023, which was when i created this parameter and hasn't updated since, even when the MaxDate (2) list has updated to 28/02/2023.
Is there any possible way to update this parameter. I need not necessarily use this list/table, if there is any other way to update the parameter everyday automatically, I'm open to that solution as well.
Thanks in advance!
Solved! Go to Solution.
Instead of using a paramter, I just created a table with a single cell that calculates the yesterday's date using the formula: Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)
I then add this column to my original table, where I was initially using the parameter.
Now that column updates as the above created table updates (everytime i refresh)
Instead of using a paramter, I just created a table with a single cell that calculates the yesterday's date using the formula: Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)
I then add this column to my original table, where I was initially using the parameter.
Now that column updates as the above created table updates (everytime i refresh)
Instead of using a paramter, I just created a table with a single cell that calculates the yesterday's date using the formula: Date.AddDays(Date.From(DateTime.FixedLocalNow()),-1)
I then add this column to my original table, where I was initially using the parameter.
Now that column updates as the above created table updates (everytime i refresh)
Needs more details. Is that an issue on Desktop only, or also in the service? Did you set up scheduled refresh in the service? How often?
Its on Desktop, not on service.
Even on manual refresh, the parameter does not change
Please show the code for the MaxDate (2) query.
It doesn't accept a query in the parameter, it only accepts a list.
Anyway I found an alternate solution without using the parameter. Thanks for your help
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |