Forum Discussion

Regular Visitor

10 years ago

Solved

Creating Case Sensitive Table Relationships

I am having trouble making a relationship between two tables. Due to case insensitivity, powerBI thinks that there are repeat entries on both tables and so it will not create the relationship. ...

Tips and Tricks

SqlJason
10 years ago
This case has been discussed here - https://social.technet.microsoft.com/Forums/en-US/f12496b0-7424-44e7-a384-a08694595899/power-query-load-not-maintaining-case-sensitive-data?forum=powerquery

The recommended solution was to create a dimension table as greggyb suggested - http://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/

Regular Visitor

10 years ago

Do I need to use Power Query to accomplish this or is there a way to do it all within PowerBI?

Memorable Member

10 years ago

You can edit the queries within Power BI and do the same operations (the similar feature in Excel is called Power Query, and is very similar in look and feel).