Advance your Data & AI career with 50 days of live learning, dataviz contests, hands-on challenges, study groups & certifications and more!
Get registeredGet Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Request now
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)
4. In the service, it doesn't show the time and if I type it in, it cuts it off:
Solved! Go to Solution.
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.
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.
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
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.
Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!
Check out the October 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 52 | |
| 21 | |
| 11 | |
| 11 | |
| 10 |