Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Bug? From Power Query to Power BI - TEXTchanges

Hello, is it a bug, or how can i solve this problem? [Power Query]              [Power BI]               Nr.      Text                   Nr.      Text ..         ...                      ..  ...
Need Help
Anonymous's avatar
Anonymous
Not applicable
4 years ago

HI Anonymous,

In fact, Power BI data model uses a case insensitive language setting. As a result, strings in the same column that differ only by cases will be consolidated into a single string depending on whichever happens to be imported first. Query Editor UI displays the strings in the original case before the Import, and Data View shows the strings after the Import.

Regards,

Xiaoxin Sheng

  • Anonymous's avatar
    Anonymous
    Not applicable
    4 years ago

    Well, the question now how can i solve this problem?
    Cause if i want to build a data model i get n:m relationship and not 1:n, cause BI changes the Data in DIM sheet and not in FACT sheet.