How to insert a Today parameter within Power BI service

[WTsrnl]

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.

[aj1973]

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