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...
Need Help
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

     

     

    • Anonymous's avatar
      Anonymous
      Not applicable
      8 years ago

      Hi zlokesh,

       

      Thank you for the reply!

      Actually the thing is because Power BI considered this as duplicate record, I am not bale to make relationship between two columns.

      I have another table called 'Opportunity_forecast', I want to make joined between 'Opportunity' table and 'opoortunity_Offer' table. but as Power Bi consider duplicates records in both the table. Many to Many join is not possible. How should I solved this problem?

      • v-jiascu-msft's avatar
        v-jiascu-msft
        Microsoft Employee
        8 years ago

        Hi Anonymous,

         

        1. Can you count some case sensitive Opportunities_id as one? If you can, I would suggest you create a middle table like below.

        Opportunity = values(v_opportunities[Opportunity_ID])

        2. If they are different records, are there any other fields that can help to identify the records? If there are, I would suggest you combine two or more columns as one and take it as ID.

         

         

        Best Regards,

        Dale