Power BI x ChatGPT x Power Apps | Use ChatGPT and Power Apps to Analyze Data in Power BI | TUTORIAL
Вставка
- Опубліковано 15 жов 2024
- Today, I'm showing you how to use ChatGPT to analyze Power BI data through a Power App and a custom ChatGPT connector!
This video builds upon my original ChatGPT x Power BI tutorial, which you can view here: • ChatGPT x Power BI | U...
Thanks for watching. Like and subscribe for more, and let me know what you want to see next in the comments!
#ChatGPT #PowerBI #PowerApps #AI #Data #SomeGuyNamedChris #PowerPlatform #Microsoft #Analysis
Chapters:
0:10 Overview
1:17 Custom Connector
6:25 Test the Connector
7:25 Copy and Paste Response
8:20 Add Power App
9:15 Add Fields
15:50 Preview Power App
16:40 Create Send Button
20:27 Publish Power App
21:18 Refresh Power BI
Very interesting solution using low-code! I imagine that it would be possible to implement an agent within Power Automate with a loop associated with DAX Queries sent to the dataset, this would allow the agent to interact with the dataset (sending DAX queries) to answer questions.
Hey Chris, very interesting approach. After more than a year to your project, how much do you think those technologies have involved? Would it be possible to use this approach to a much greater dataset using Power BI as a datasource? Moreover, if your Power Bi has tables with relationships to each other, would that help ChatGPT to provide accurate answers, or it would make more difficult?
Wow excellent tutorial, I may have trouble analyzing a larger amount of data, but it's a great starting point for integrating Chat GPT and Power BI
A great tutorial as always!
Interesting tutorial
Hi Chris,
Not getting any option to create a custom connector, I have a Powerapps per user license.
You mention "we're going to use the same body that we've built previously" at 3:46, where can I find this?
Hey Moses, you can find the video here: ua-cam.com/video/q1XszZrZ3es/v-deo.html
@@someguynamedchris Yup! I dug around your videos and found it eventually lol
Thanks for replying, hope all is well!
@@someguynamedchris Actually it would be really helpful if you could put your body code here...
Is there anyway to do it dynamically, I want to be able to use this on larger data sets without having to create a new power app everytime.
Hey Allen, there may be a way, but there are limitations on how much data can be passed through the API.
@@someguynamedchris Hi, could you tell me Where can I check the limitation on Data ? I have try your demo with a huge data size, but then I received the respone "Server Response: _scrubbedSensitiveData_"
@@MinhTran-go6kd The limitation sizes are on the open.ai website under the documentation for the API.
my app is working fine on power app but on power bi it is not showing any response. Can someone help please
What if I want to connect to SSAS ?
Hello Chris - Would you be open to chatting about training opportunities with O'Reilly Media?
what is text-davinci-003???
what should I give instated of text-davinci-003
It would depend on what you are trying to accomplish. The OpenAI API documentation has different models for different processes.