Using advanced AI to analyze free-form text

[acamar22]

Hi guys!

I'm looking for some direction using AI in my imported data sets. I have mass data sets with complex free-form text.

I've done some research, and it looks like the built-in AI is not advanced enough.

Ideally, I'd like a chatGPT type AI where I can type a prompt and the AI searches for specific scenarios/keywords.

Using things like Text.Contains() is not ideal as there are so many variations of keywords I'm looking for.

example) "Analyze columns that indicate a part failure: if provided, record part number and failure mode."

Is something like this possible? If so, what programs do I need? I'm willing to learn any skills needed.

Thanks all!

[v-xinruzhu-msft]

Hi @acamar22 

In Power BI, it offer thr Copilot, you can refer to the following link about it.

Use Copilot in Power BI Desktop - Power BI | Microsoft Learn

Best Regards!

Yolo Zhu

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.