Forum Discussion
Anonymous
4 years agoNot applicable
Case sensitive issue when Power BI connects to sql tables
I'm trying to switch Power BI tabular model among different sql servers. The table names may have different upper or lower cases across servers. Since power query is case-sensitive, it fails to connect when in some environment the table name shows as "dimcustomer" instead of "DimCustomer". Are there anyway to make it case-insensitive? Thanks!
I set up three parameters (Server, Database, SchemaParam) for easy switch among various environment.
let
Source = Sql.Database(Server, Database),
Customer = Source{[Schema=SchemaParam, Item="DimCustomer"]}[Data],
not its a base behavior of power query its case sensitve for all references, label, etc
1 Reply
- StefanoGrimaldiResident Rockstar
not its a base behavior of power query its case sensitve for all references, label, etc