using Azure Open AI (chatgpt) in power virtual agents to query SSAS tabular models

Closed Posted 8 months ago Paid on delivery

$250-750 USD

Paid on delivery

Closed 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.

Microsoft Azure OpenAI Power Automate Power BI Virtual Assistant

Project ID: #37135268

About the project

7 proposals Remote project Active 7 mos ago

Looking to make some money?

Benefits of bidding on Freelancer

Set your budget and timeframe
Get paid for your work
Outline your proposal
It's free to sign up and bid on jobs

7 freelancers are bidding on average $779 for this job

dataspro's Profile Picture
dataspro

Nice to talk you anilreddy77999, After reading in detail the requirements of your project and concluding that they match my areas of knowledge and skills, I would like to introduce myself. My name is Anthony Muñoz an More

$1000 USD in 7 days
(0 Reviews)
0.0
AyavinSolutions's Profile Picture
AyavinSolutions

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

$750 USD in 7 days
(0 Reviews)
0.0
rupjyotideka11's Profile Picture
rupjyotideka11

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

$1000 USD in 15 days
(0 Reviews)
0.0
parth1729's Profile Picture
parth1729

Thank you for the opportunity and for sharing details about your SSAS natural language query project. Unfortunately, I do not have the required skills in Azure services, Power Platform, and SSAS to complete this projec More

$750 USD in 7 days
(0 Reviews)
0.0
techindia999's Profile Picture
techindia999

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

$750 USD in 7 days
(0 Reviews)
0.0
bdrudra's Profile Picture
bdrudra

Hello, I hope you're doing really well. I review your requirements and I can do this work. I have worked with Microsoft technologies for 9+ years and helped clients get the most out of the SharePoint, Azure, PowerApp More

$700 USD in 7 days
(0 Reviews)
0.0
officeraju's Profile Picture
officeraju

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

$500 USD in 7 days
(0 Reviews)
0.0
Post a project like this