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 is that some links for certain years have capitalized letters and others don't. Everything else is the same, just the case of a few letters. What adjustments can I make so that the case is ignored for this?
2 Replies
Anonymous,
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.aspxRegards,
Charlie Liao
