Forum Discussion
NBR_22
2 years agoFrequent Visitor
Spell Check PowerBI
Hello, I want to do spell check for each row in a column, is there a function or something that I can use to check spell check and return a false or true if the word is correctly spell? Regar...
pmreis
2 years agoMost Valuable Professional
Hi NBR_22
Natively there isn't a way to do it as per my knowledge. However you can create a custom function which uses a spell checking API.
For instance, using the Bing Spell Check API:
- Sign up for the Bing Spell Check API and get your API key.
- Create a custom function in Power Query to call the API.
- Invoke the custom function on each row
Here is some sample code, auto generated by AI, I didn't test it:
let
CheckSpelling = (word) =>
let
apiUrl = "https://api.cognitive.microsoft.com/bing/v7.0/spellcheck?text=" & word,
headers = [#"Ocp-Apim-Subscription-Key" = "Your_API_Key_Here"],
source = Json.Document(Web.Contents(apiUrl, [Headers=headers])),
result = source[flaggedTokens] // Check if there are any flagged tokens
in
List.IsEmpty(result) // Returns true if the word is correct, false otherwise
in
CheckSpelling​
Pedro Reis - Data Platform MVP / MCT
Making Power BI and Fabric Simple
If my response resolved your issue, please mark it as a solution to help others find it. If you found it helpful, please consider giving it a kudos. Your feedback is highly appreciated!
Find me at LinkedIn