How to Make a Power Query Step NOT Case-Sensitive
This is about how to make a Power Query step not be case sensitive (aka case-insensitive). This can be useful in filters and replacer steps where you don’t have perfect data quality.
This will work with both Power BI Power Query and Excel Power Query.
🛠️ RESOURCES
How to make a replacer step case-insensitive (Gorilla BI): https://gorilla.bi/power-query/replac...
Ignore ordinal case documentation: https://learn.microsoft.com/en-us/pow...
⏲️ TIMESTAMPS
0:00 Intro/use case
0:54 Add code for case insensitivity to step
1:47 Why you might do this vs using SharePoint metadata
▶️ RELATED VIDEOS
Schedule refresh on SharePoint / file sources in Power BI: • How to Schedule REFRESH on File & Fol...
🪽 CONNECT WITH ME
Blog: https://christine-payton.com/
LinkedIn: / christinehpayton
🎁 SUPPORT THIS CHANNEL
Shop: https://shop.bi-ome.com/
#powerquery #powerbi
Watch video How to Make a Power Query Step NOT Case-Sensitive online without registration, duration hours minute second in high quality. This video was added by user Christine Payton 15 October 2024, don't forget to share it with your friends and acquaintances, it has been viewed on our site 255 once and liked it 13 people.