Forum Discussion

BM4291's avatar
BM4291
Icon for Resolver I rankResolver I
4 years ago
Solved

PowerBI Paginated - Date Parameters use different locale

Hi,   In the past week or so we've noticed some odd behaviour in a handful of paginated reports in the PowerBI service; they're displaying UK date formats (dd/MM/yyyy) to the user, however when ren...
Need Help
  • BM4291's avatar
    BM4291
    4 years ago

    Thanks Tutu_in_YYC ,

    This error is slighlty different in that the values shown on the screen are in the correct locale, and are even passed back to the report in the correct format; it's that DATEVALUE() is then rendering them in a different locale despite the model, browser, and user being set to UK.

     

    The workaround I've highlighted above does the trick for now.

BM4291's avatar
BM4291
Icon for Resolver I rankResolver I
4 years ago

Thanks Tutu_in_YYC ,

This error is slighlty different in that the values shown on the screen are in the correct locale, and are even passed back to the report in the correct format; it's that DATEVALUE() is then rendering them in a different locale despite the model, browser, and user being set to UK.

 

The workaround I've highlighted above does the trick for now.

  • Tutu_in_YYC's avatar
    Tutu_in_YYC
    Icon for Super User rankSuper User
    4 years ago

    Thanks for the additional information!