ICS-IT's avatar
ICS-IT
Regular Visitor
8 years ago
Status:
New

Localization problem (cyrillic symbols)

I have installed PowerBI from MS Store on my surface book 2 and when I'm trying to get data from sql server all cyrillic letters are replaced by question marks like on the screenshot attached. On other laptops the same data in PowerBI has all correct cyrillic symbols.

Also when I open Power Query window in Power BI on my laptop all cyrillic letters are correct. I've already tried to change localization settings in PowerBI, Windows and nothing have helped.

  

 

Thanks, Alexander

Dashboards
Data Modeling
Reports

5 Comments

  • DrS's avatar
    DrS
    New Member
    8 years ago
    I have same problem... 'Stacked column chart'.
  • DrS's avatar
    DrS
    New Member
    8 years ago

    My problem solved when I changed view definition on SQL server:

     

    Before:

    CREATE VIEW [dbo].[DrS__data_for_Power_BI]
AS
SELECT      COUNT(id) AS N'Број', areaName AS N'Облас'''
FROM        Recur
WHERE      parentId = 666999
GROUP BY areaName

     

    Now:

    CREATE VIEW [dbo].[DrS__data_for_Power_BI]
AS
SELECT      COUNT(id) AS N'Број', CAST(areaName AS nvarchar(255)) AS N'Облас'''
FROM        Recur
WHERE      parentId = 666999
GROUP BY areaName

     

    Although areaName is defined as nvarchar, I had to CAST it. :(
    At least, it wasn't problem in Power BI Desktop.

  • ICS-IT's avatar
    ICS-IT
    Regular Visitor
    8 years ago

    Solved it by changing language for non-Unicode programs in Region settings.

Completed Ideas