using Azure Open AI (chatgpt) in power virtual agents to query SSAS tabular models
$250-750 USD
Paid on delivery
Agenda: To be able to provide chat bot experience for the users to query the SSAS tabular models in natural language and bring back the results from the tabular model.
Below is my thought but doesn't necessarily have to follow the same approach.
1. Pull the tabular metadata (Table, columns, list of measures) into file.
2. Train/Prompt Azure Open AI services with this metadata so when the users hit this model with question, it gives us appropriate query based on metadata provided instead of generic query.
3. Use Power Virtual Agent to provide chat experience to the users and call Azure Open AI service to pull the relevant dax query for the cube and then trigger power automate flow to pass the dax query to the cube and fetch the results back to user.
4. Publish the chat bot as web app.
SSAS Tabular Model Version - 1500 compatibility.
Project ID: #37135268
About the project
7 freelancers are bidding on average $779 for this job
Hello there! My name is Samira and I am a Lead Architect and Technical Consultant with 15+ years of experience working in Microsoft ecosystem. I understand that you are looking for someone to implement Azure Open AI More
Hello there! My name is Rupjyoti and I am a data enthusiast, with 10 years' experience in data solutions. I understand that you are looking for someone to use Azure Open AI (chatbot) in power virtual agents to query SS More
Hi Greetings! We are team of software developers. We have developers working on almost all the technologies. We will assign you a project manager who will assist you during entire process of project completion. We wil More
I have a experience of 27 years developing applications for various verticals on Web, Desktop, Mobile apps. I have experience in grooming the RPA Centre of excellence, also with building ai/ML application with chat bot More