Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Not recognizing Collation in Power BI

Hi,

 

I am very new to Power BI.

I have connected my Power BI reports to MSSQL. In Sql, we have collation setting on. so for one opportunity id it is showing only one record in database side.

But in Power BI reports, it is still showing multiple records for that opportunity id. Is there any setting in Power BI to activate Collation?

I will really appreciate any help on this.

Thanks!

 

Regards,

Poonam

Need Help

5 Replies

  • zlokesh's avatar
    zlokesh
    Resolver I
    8 years ago

    Hi Anonymous,

                         Please check the filters which applied on Visual Level/Page Level/Report Level/Drill Through.. or any grouping / where condition in query. As per your issue, it does not look for the Collation issue.

     

    Thanks

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi zlokesh,

       

      Actually the thing is in Sql database I have Opportunities id's : '0064100000ABRjE' , '0064100000ABRje', '0064100000ABRJE'.

      But in Power BI when I am loading the data, it is considering the above value as one opportunity_id. See the below image.

      I want this Id should be case sensitive and should be loaded as it is from the database. Is there any solution for that?

      Thanks!

       

      Regards,

      Poonam

       

       

      • zlokesh's avatar
        zlokesh
        Resolver I
        8 years ago

        Hi Anonymous,

         

               Please go through the below screen shots you will get Idea. I know this is not exact solution, it might have some another way, but I had same issue and tried the below method.

         

        IssueSolution