Forum Discussion

WTsrnl's avatar
WTsrnl
Advocate I
3 years ago

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.