Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

SET DATEFIRST 1 in Direct Query mode

I am completely out of ideas.    My data is all structured to look at Monday as the first day of the week but I am using an Azure SQL backend so I can't change the default value which is set to Sun...
Need Help
v-huizhn-msft's avatar
v-huizhn-msft
Microsoft Employee
8 years ago

Hi Anonymous,

Monday is the first day of week in Azure SQL, you want to change date format Sunday as the first day of this week when you get date in Power BI desktop in direct Query Mode, right? If it is, we can not change it, you connect date of database directly rather than importing data to the local when you use Direct Query model, please review this feature request below and vote it.

Improve Direct Query Date Time Handling

Thanks,
Angelia

  • Anonymous's avatar
    Anonymous
    Not applicable
    8 years ago

    v-huizhn-msft,

     

    Thanks for the reply. 

    I can;t get Azure to see Monday as the first day no matter where I go. I think a few too many features have been turned off unfotunately .