Forum Discussion

apollnor's avatar
apollnor
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's avatar
    v-haibl-msft
    9 years ago

    apollnor

     

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

     

    Best Regards,
    Herbert

  • apollnor's avatar
    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's avatar
apollnor
Advocate II
9 years ago

If I do a simple test and import the data from only the table the measure needs to work with, I have no problems using Norwegian Locale. However, If I do the same, only in DQ mode, I'm back to getting the error message...

 

The conversion of a nvarchar data type to a datetime data type resulted in an out-of-range value... The exception was raised by the IDataReader interface.

 

As the source SQL-server is my own, I have also tried to change the language of the SQL instance to my own native, just to check if it had any effect, but it did not.

 

I found a similar post on the forums, where the exact same problems are described: http://community.powerbi.com/t5/Desktop/Locale-settings-not-working/m-p/49588/highlight/true#M19771