Bug? From Power Query to Power BI - TEXTchanges

Question

Hello,is it a bug, or how can i solve this problem?[Power Query]&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; [Power BI]&nbsp;&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nr.&nbsp; &nbsp; &nbsp; Text&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;Nr.&nbsp; &nbsp; &nbsp; Text..&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;...&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ..&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;..&nbsp; &nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; BackOffice&nbsp; &nbsp; &nbsp; &nbsp;&nbsp;7&nbsp; &nbsp; &nbsp; &nbsp; BackOffice&nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; Backoffice&nbsp; &nbsp; &nbsp; &nbsp; &nbsp;8&nbsp; &nbsp; &nbsp; &nbsp; BackOffice..&nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; &nbsp; ...Why do PBI do text changes? What goes wrong?Ich checked, all the data is TEXT.Thanks

anonymous · Answer

HI&nbsp;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 · Answer

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.&nbsp;

Forum Discussion

Bug? From Power Query to Power BI - TEXTchanges

2 Replies

Related content

Power Query dates

Data transform using power query

ayuda en power query

Power BI downloaded PBIX does not contain Power Query queries

Power Query