Connect Salesforce and Power BI

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)

Case ID	Case Subject	Case description	Category
332432	AAAA	blah blah	customer complaint
4243242	BBBB	something	product quality
424234	CCCC	bleh	customer praise

Thanks!

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