Forum Discussion
How to insert a Today parameter within Power BI service
Hi guys, I have had this question for a while now. I've seen several posts on reddit and this platform about working with Power BI parameters within Power BI desktop to reduce the dataset size, in such a way that you can easily go back and forth between PQ editor and building a report.
Now that I've published the report, I've still got the PQ parameters on the dataset.
Within Power BI desktop i used the below M code:
DatumTijdVandaag = DateTime.ToText(DateTime.LocalNow())
and converted it to a list.
In that way i can use it within the parameters in Power BI desktop.
My parameter looks like this:
The parameters tab in PBI Desktop
However, when I try to use that parameter within the Power BI service refresh settings, it doesn't show up. It just takes the Current Value from the PBI desktop. I want to keep myself from continuously updating the parameter, so for now I've just set the date in the future. However this is not ideal.
Does anyone have a good blog post about this, since I can just find ones that are about the Power BI desktop parameters. Or can someone explain me how I can solve this?
Also, please let me know if I've misunderstood the best practice, and tell me what the best way forward would be for a dataset with +40m rows.
1 Reply
- aj1973Community Champion
Hi WTsrnl
I think your aim is to introduce the incremental refresh into your dataset to reduce it ! if so refer to this to configure it
https://learn.microsoft.com/en-us/power-bi/connect-data/incremental-refresh-configure