Forum Discussion

Advocate II

9 years ago

Solved

Problems with DAX, SQL and locale

Server OS: Windows Server 2016 Server Region & Language: Norway Server Formats: Norwegian Bokmål (Norway) SQL Instance Version: Microsoft SQL Server 2016 (SP1) Instance Collation: Danish_Norwegia...

Need Help

v-haibl-msft
9 years ago
apollnor

The fix will be available in August 2017 version of Power BI Desktop.

Best Regards,
Herbert
apollnor
9 years ago
cxtale: That's strange, after the update (i just downloaded it as i read what you wrote), this seems to have been fixed for me.

Version: 2.49.4831.521 64-bit (august 2017)

apollnor

Advocate II

9 years ago

I see. I am the one building the DWH so changing it wouldn't be a major problem, just time-consuming and perhaps changing the defaults of the DWH will affect something else in the future, so I would rather stick to having consuming applications adapt to the DB time format.

But am I correct in assuming that the locale settings in the PBIX or locale transformed date column should adjust for this, however, they are not, and the team will have a look at it? Not sure if I should keep working on a permanent workaround or wait for a new release, see :)