Power BI 中的区分大小写 [英] Case sensitivity in Power BI

问题描述

我想知道是否可以在 Power BI 中配置区分大小写.我在 Oracle DB 中有数据，其中主键 EXample 与 exampLE 不同.但是如果我想在 Power BI 中导入它，它就行不通了.

I wanted to know if it's possible to configure the case sensitivity in Power BI. I have data in an Oracle DB where a primary key EXample is different from exampLE. But if I want to import it in Power BI, it won't work.

有什么想法吗?

推荐答案

目前，我认为最好的办法是在查询编辑器阶段为您的主键创建一个索引，然后在 Power BI 中为您的关系.

For now, I think your best bet would be to create an index for your primary key in the query editor stage and then use that index in Power BI for your relationships.

此处概述:

http://www.thebiccountant.com/2015/08/17/create-a-dimension-table-with-power-query-avoid-the-bug/

您也可以在此处投票支持区分大小写:

You can also vote for case sensitivity to be configurable here:

https:///ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/17235656-case-sensitive-insensitive-option

这篇关于Power BI 中的区分大小写的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！