Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now

Reply
Anonymous
Not applicable

Paginated report parameter not showing time portion

I've created a paginated report using report builder. It works correctly in the report builder app but is truncating the time in the power bi service.

 

1. Parameter is date/time

2. Default value is: =DATEADD("d", -7, Now())

3. Run the report in report builder (correct)

report builder date and time.PNG

4. In the service, it doesn't show the time and if I type it in, it cuts it off:

service date and time.PNG

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Ended up adding time parameters from a list of availabile hours based off my time dimension. That way the user can only enter valid time. I combined the date & time parameters together to pass to the results dataset parameter. This works well in the service.

View solution in original post

3 REPLIES 3
Anonymous
Not applicable

Ended up adding time parameters from a list of availabile hours based off my time dimension. That way the user can only enter valid time. I combined the date & time parameters together to pass to the results dataset parameter. This works well in the service.

GilbertQ
Super User
Super User

Hi @Anonymous 

 

It would appear to me that either the parameter is set to date?

 

Or it is chopping it off.

 

If it is the latter I would log a support ticket to let the Power BI Team have a look

https://powerbi.microsoft.com/en-us/support/pro/





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Anonymous
Not applicable

It is chopping it off only in the service. When running it from Power BI Report Builder, it contains the date and time. I've created a workaround to separate the date and time into separate parameters. The time has to be text through, or the date keeps appearing. So odd! I'm logging a support issue as it seems a bit much to have a true date & time parameter.

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Kudoed Authors