Hello,

Im trying to connect a filtered case list (https://company.lightning.force.com/lightning/o/Case/list?filterName=blahblah) containing customer reviews in the case description into a Power BI table and connect it to my AI Hub custom prompt bot that categorises text. Ideally, when new cases get added to that filtered list –  the Power BI table automatically refreshes with the case id, subject, description and an additional column where the categorised text gets added in.

eg)

Thank you for reading this post, don't forget to subscribe!
Case IDCase SubjectCase descriptionCategory
332432AAAAblah blahcustomer complaint
4243242BBBBsomethingproduct quality
424234CCCCblehcustomer praise

Thanks!

Question Answer

You might find it helpful to follow these steps:

1. Connect Salesforce filtered case list to Power BI.

2. Use Power Apps AI Builder to categorise case descriptions:

  • Create a Power Automate process that triggers on Salesforce case updates.
  • Use the Power Apps AI Builder model to classify case description fields.
  • Update the classification results (e.g. ‘customer complaint’, ‘product quality’, etc.) to a new column, write back to a shared database or file store, or update the corresponding record in or update the corresponding record in Salesforce.

3. Configure Power BI to automatically refresh for the latest classification results.

4. Displaying Classified Data in Power BI

Related Posts
Salesforce OEM AppExchange
Salesforce OEM AppExchange

Expanding its reach beyond CRM, Salesforce.com has launched a new service called AppExchange OEM Edition, aimed at non-CRM service providers. Read more

The Salesforce Story
The Salesforce Story

In Marc Benioff's own words How did salesforce.com grow from a start up in a rented apartment into the world's Read more

Salesforce Jigsaw
Salesforce Jigsaw

Salesforce.com, a prominent figure in cloud computing, has finalized a deal to acquire Jigsaw, a wiki-style business contact database, for Read more

Health Cloud Brings Healthcare Transformation
Health Cloud Brings Healthcare Transformation

Following swiftly after last week's successful launch of Financial Services Cloud, Salesforce has announced the second installment in its series Read more