Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago

date picker format in Power BI Report Server

Hi, is there a way to get the date format correct in Power BI Report Server on the date pickers? Currently my date pickers are correct (UK format) when published to Power BI Service, but on Report Server they appear in American format.

 

 

Need Help

2 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    9 years ago

    Hi Anonymous,

     

    Which kind of the date picked did you mean? Can you share a picture?

     

    As Power BI report server is on premise, please check which date format is set for the machine that has Power BI report server runs.

     

     

    Best Regards,
    Qiuyun Yu

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      Hi, I'm using the standard slider for Between dates.

       

      I've checked the locale/regional settings of the SQL Server and they appear correct (dd/MM/yyyy).

       

      With the same pbix file published to Power BI service the date format is correct, its just Report Service with the issue.

       

      Are there any other SSRS (or elsewhere in SQL) date options that it could be picking up somewhere?