Forum Discussion
Ignoring case when importing from multiple webpages
I followed the directions here: https://www.youtube.com/watch?v=6PZSZ53iSos I was able to set up my query and turn into a parameterized funcion based on the year in the URL; the problem I'm having ...
v-caliao-msft
Microsoft Employee
Microsoft EmployeeAnonymous,
You could load your data into Power BI data model first, and then convert the text by using LOWER function which converts all letters in a text string to lowercase.
https://msdn.microsoft.com/en-us/library/ee634251.aspx
Regards,
Charlie Liao
I don't think that addresses my issue - I'm referring to website URLs when importing data into the query editor