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
kelvinngai
Advocate I
Advocate I

Date range slicer did not show correct end date when passing parameters from embedded powerBI

Hi all,

 

anyone has idea how the date range works with embedded powerBI? When we pass the date range from embedded report APIs, it shows different behavior for 'FromDate' and 'EndDate'

 

https://playground.powerbi.com/dev-sandbox?showApi=reportSetSlicerState

The paramter is in UTC time, does it convert to local time in the report?

even there is a conversion to local time, 'FromDate' and 'ToDate' are not consistent. 

e.g.  The date range is from 

2014-10-12T11:00:00.000Z
to
2014-11-28T11:00:00.000Z
 
So they should either 12/10/2014 to 28/11/2014  or 13/10/2014 to 29/11/2014 as the time are the same.

kelvinngai_0-1627270568755.png

 

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi,  @kelvinngai 

It's really weird. I tested it on my side and there was a similar situation. The result is a bit different from yours. I doubt whether this is related to my time zone or  my browser locale.

9.png

If you received any feedback for MS support engineer, please kindly share here.Thanks.

 

 

Best Regards,
Community Support Team _ Eason

kelvinngai
Advocate I
Advocate I

anyone got the same issue?  

 

I just raised an issue ticket as well. Hope to get reply soon

 

Thanks

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