Power BI integration with AI / ML / Bard

[PavBidani]

Power BI – Power Automate --  Bard

Hello All,

Requesting assistance with Power BI Integration with Bard

Data has multiple records for many us cities (more than one record for each city).  Need state, region, latitude, and longitude for each city to show maps to end user.

My thoughts –

• Create a distinct list of cities in PBI via dax
• Use Power Automate to send this list to Bard – Prompt – for the attached list of cities, please return state, region, latitude, and longitude
• Get back the state, region, latitude, and longitude for each city from Bard via Power Automate. 
• Use this data to create the maps

I will greatly appreciate your suggestions and any coding help for Power Automate and Bard.

Also open to other better ways to get the desired results.

Many thanks!!

Pav

[amitchandak · Accepted solution]

@PavBidani , refer if these can help

https://www.youtube.com/watch?v=xBF_ZaGW87k

https://www.youtube.com/watch?v=m2Rov1x3mIE

[PavBidani]

Excellent!

Thank you!!

Pav