Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
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],
Solved! Go to Solution.
not its a base behavior of power query its case sensitve for all references, label, etc
Proud to be a Super User!
not its a base behavior of power query its case sensitve for all references, label, etc
Proud to be a Super User!
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
| User | Count |
|---|---|
| 19 | |
| 9 | |
| 8 | |
| 7 | |
| 6 |