The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends September 15. Request your voucher.
Hi,
Was attempting to use text analytics function to extract key phrases from "Comments" column and it returns an error
= AIFunctions.PostProcess(Table.AddColumn(#"Added Custom1", "Extract key phrases", each #"Extract key phrases"([Comments], "en-us")), "Extract key phrases", "CognitiveServices.ExtractKeyPhrasestexttext") meta [FunctionBrowser="TextAnalytics"]
Error:
Expression.Error: We cannot convert the value "[Function]" to type Function.
Details:
Value=[Function]
Type=[Type]
Was suspecting the nulls in comments field perhaps? or would it matter if there is alpha numeric in th field
Estoy teniendo ahorita un error parecido, cómo lo solucionaste ?
Hi @Anonymous
I don't see "AIFunctions.PostProcess" in any Power Query References documents.
You could refer to the completed guide below:
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi
Unfortunately i was really looking foward to using some osrt of text mining functionality to extract patterns of words from comments.
The text Analytics function is allowed for being a premium user I suppose.
This error appears even if the datatype is consistent on fields where no nulls. Is there anything else you can assist with?
Expression.Error: We cannot convert the value "[Function]" to type Function.
Details:
Value=[Function]
Type=[Type]
Hi @Anonymous
You could show your detailed needs, we may solve it by other ways.
Best Regards
Maggie