You will need to create a connection from Power BI to Power Automate, from within Power BI. This would then have the Power BI dataset from within Power BI, flowing into Power Automate. You can’t just start in Power Automate to perform these actions.
Hi Chris, thanks its a great solution out there! Any idea if ChatGPT account should be upgraded to a payment plan so the API will return data? Since the solution is not working with me.
Hey Stephan, ChatGPT may have changed from a free evaluation version to a paid version a while back. Do you receive any error messages when running? You can try to feed in the data manually through something like Postman and it may give you a better idea of why it is not returning.
I don't know of a way to trigger, with the exception of if you only want this to fire on a certain selected value in the dropdown, you could add a condition into Power Automate. At the same time, I may try and look as I like the idea.
Karthik, based on the permissions error, it appears that perhaps one user created the Streaming Dataset, while another user is trying to read it from a Workspace. Have you looked at the permissions and ensured the other user has access permissions? If you need additional help, can you please provide the steps you are doing and I might be able to more accurately diagnose the issue.
After further research, it appears that this a bug in Power BI: community.powerbi.com/t5/Desktop/Regression-on-direct-query-over-Streaming-Dataset/td-p/3052320
@@someguynamedchris I am getting the same error. Both the ids that i have checked are same. I am following exactly what you have shown in the video. When i click on Power BI datasets i get the option to select Chat GPT Reply. But as soon as i click on it, i get the same error. Any other alternatives to this?
Kind of cool, and thanks for sharing, but I did a simply test and submitted 72 numbers in a list and asked it how many numbers were in the list. It said there were 60. I asked it to sort them ascending. It did it. I asked where the number 14 went? It said sorry for the oversight. .... there were many "oversights", so I wouldn't trust this for any analysis if it can't count 72 numbers.
Love this video and have gone through this several times. Ran into the myworkspace issue as described below as well but was able to connect to the dataset in a new workspace. odd for sure. Now I feel like im stuck at a rudimentary step and the button wont click.. the flow is perfect... but cant get the button to run flow.. any ideas?
Hey mark can you tell how you came through that workspace issue ? Still it is saying same thing that database is not exist or you don't have permission
Hey Mark, glad you enjoy the video! If you are in Power BI Desktop, you'll need to hold the CTRL button down while clicking the button. Once published, the button should be clickable without CTRL.
Hi Chris, I tried to create flow as I would like to get responses for every row in my database. but I couldn't! do you know how to help with this flow?
RS, are you receiving an error message when creating the flow? Remember, the flow would need to be created and edited through Power BI as it has the additional triggers and actions. You would then be able to see the flow in your My Flows, but not all capabilities would be available. If you'd like, you can send me a screenshot through Facebook messenger; the link to my Facebook profile is on my channel. Thanks!
Wow.. Amazing tutorial. Do you know if it's possible to show a Blank field to allow the end user to write a question to get some insights based on ''his data'' ? I'm also new in power automate so I'm not sure if you can only set one task per need or it could be more flexible to adress more requirements from just one field in power Automate with gpt.
Hey Joel, thanks for watching. As far as I am aware, there is no user input feature other than dynamic parameters, which I believe are numeric entries. You could write up different text options within a table and do a selection while submitting. I would ensure you can only select a single text option, but once it is selected, you can send that into Power Automate and replace the predefined message with the selection text.
@@someguynamedchris I really like Joels questions, its the same as mine lol. Looking at this though, If the data model was direct connection to an SQL Table and the Power BI report had an embedded Power App in it, where the user could type out a question, could that field from the streaming data set be used as a dynamic input into PA and Chat GPT ?
power bi for PBI dataset option is not visible at my end and on using power bi dataset from get data, it shows direct query is not available for this dataset. Can someone please help.
The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: d. Path '', line 0, position 0.'. Getting this error.
Hey Chris!I followed your steps, however after 15 min running time, i receive following error: Action 'HTTP' failed You exceeded your current quota, please check your plan and billing details. Can i use it without buying openai subscription?
Hey Roman, it appears either your free trial has expired or if you recently signed up, you may not have received a free trial, and you would need to purchase a subscription through OpenAI.
Hi chris, i am able to get the answers for general questions from chatgpt, but when i click to add dynamic contents, i am not able to find the option "PowerBI data", What might be the reason.
So the data has to be within the token limit. You'll find more information about your limit at this link under "Managing Conversations" learn.microsoft.com/en-us/azure/cognitive-services/openai/how-to/chatgpt?pivots=programming-language-chat-completions
Hi Chris - Getting an error from the run history, stating 'Invalid URL (POST /v1/chat/completions)' - Is the model down? (I can list the models via Postman so my key is good) Thanks for everything!
Hey Jimmy, I haven't heard anything about the system being down. If you want me to look at the HTTP step, commenting out the API key, I could see if anything is off. But if it was working previously, I will have to do some additional tests.
Hi Chis, When I am adding ChatGPTReply from Power BI datasets I get an error. "Value cannot be null. Parameter Name:Data Source". I noticed that others here had the same problem can you help us? thanks.
I solved it, the database name must be the same as the streaming dataset, I advise you to create a new workspace and put the dashboar, the table and the streaming database in the same connection so as not to confuse and redo the process. hugs
Hey Chris! thanks a lot for this video, it helps me a lot! It seems chatGPT api (DaVinci) is making lot of error when analysing PowerBI Data using the method you shared. I wonder if that might be due to the data format used (in this case Dynamic content > PowerBI Data). Do you have advices to share table to chatgpt in the best format possible to reduce the risk of error?
Glad the video helps! Unfortunately, I don't have a best practice format for sending in data to ChatGPT. It states it can read tabular data, but I am sure complex formats may be tough. You could potentially try and send in a schema with the data, it may be able to read and utilize the schema to better understand the data.
Great Video Chris, I was wondering if you know how to handle this error. When I am adding the ChatGPTReply from Power BI datasets, I get an error. "Value cannot be null. Parameter name:Data Source". Appreciate the content!
Glad you like the video! What's interesting is that I think I received this error message earlier in the week when trying to overcome the composite issue with the Add to Local Mode, but I don't remember exactly. I'll review my notes and run some tests to see if I can find a solution for you!
I solved it, the database name must be the same as the streaming dataset, I advise you to create a new workspace and put the dashboar, the table and the streaming database in the same connection so as not to confuse and redo the process. hugs
@@robotics11001001 I'm a bit confused in doing this process. I thought that I named everything the same but is it possible to contact you for some help? I can't seem to figure it out!
Hey Chris, nice demonstration! I am building a PowerBI custom visual in R like I have done many times, but this time using ChatGPT with Azure-OpenAI. Do you know how I can get the Dynamic-Content->PowerBI Data inside R Visual, or to provide an idea of retrieving data from report level?
Value cannot be Null. Parameter name : Date source Getting this error, could you please help me with this? This is happening when i'm trying to get Power BI Datasets after connection.
Great video Chris. But I am also facing the same error of adding a streaming dataset as a local model. The other data sets work and streaming does not. Do you have an alternative solution?
Hey Arul, the only alternative solution I can think of would be writing a custom connector for Power BI. If anyone else has a suggestion, feel free to reply!
chatGPT is not very good with math (sometimes even simple calculations). This is an obstacle for data analysis, but he is relatively good at writing code and if the mathematics is done by the code generated by chatGPT we will have more interesting results.
I haven't tried to clear the dataset. However, the option to not maintain history in the streaming dataset may work. The other option would be to try and add a filter to the grid to only show the latest result. This may take some adjustments to the streaming dataset. Just as an FYI, the current method doesn't work as well as the ChatGPT UI; it doesn't remember the previous questions and answers.
I think this is good but still a bit far from people's expection. I guess people want to like to see ChatGPT creating, or modifying visuals in Power BI based on a vague free-text instruction from the user?
There is still a lot to be desired, however, with Co-Pilot being introduced (already here), I think Microsoft is going in the direction of more automation.
Hi Chris... When we are trying to import live dataset "chatgptreply" we are facing the below issue. Could you please help. Thanks. Feedback Type: Frown (Error) Error Message: Either the database 'ChatGpt Reply' does not exist, or you do not have permissions to access it. Technical Details: RootActivityId: 8854c336-28c9-4526-aaeb-f0c3fd000415 Date (UTC): 2/28/2023 6:43:19 AM
Based on the permissions error, it appears that perhaps one user created the Streaming Dataset, while another user is trying to read it from a Workspace. Have you looked at the permissions and ensured the other user has access permissions? If you need additional help, can you please provide the steps you are doing and I might be able to more accurately diagnose the issue.
After further research, it appears that this a bug in Power BI: community.powerbi.com/t5/Desktop/Regression-on-direct-query-over-Streaming-Dataset/td-p/3052320
Chris thank you so much for the fantastic explanation
Really good tutorial. You rock. The only thing is that my company firewall has banned this workflow... I was nearly there... Thanks Chris!
HI Chris .I am not able to see PowerBI data in the https action you showd in the vedio at 14:17. Can you hep me to understand how to pass my dataset?
Same issue with me as well
You will need to create a connection from Power BI to Power Automate, from within Power BI. This would then have the Power BI dataset from within Power BI, flowing into Power Automate. You can’t just start in Power Automate to perform these actions.
@@someguynamedchris could you explain how its done? i have the same issue, my "Power BI Data" is empty in the http-request.
Thanks
Hi Chris, thanks its a great solution out there!
Any idea if ChatGPT account should be upgraded to a payment plan so the API will return data? Since the solution is not working with me.
Hey Stephan, ChatGPT may have changed from a free evaluation version to a paid version a while back. Do you receive any error messages when running? You can try to feed in the data manually through something like Postman and it may give you a better idea of why it is not returning.
Can PBI button click trigger could be customised to an existing dropdown trigger
I don't know of a way to trigger, with the exception of if you only want this to fire on a certain selected value in the dropdown, you could add a condition into Power Automate. At the same time, I may try and look as I like the idea.
Hi Chris Im getting Error like :Either the database 'ChatGPT Reply' does not exist, or you do not have permissions to access it
Karthik, based on the permissions error, it appears that perhaps one user created the Streaming Dataset, while another user is trying to read it from a Workspace. Have you looked at the permissions and ensured the other user has access permissions? If you need additional help, can you please provide the steps you are doing and I might be able to more accurately diagnose the issue.
Any luck?
After further research, it appears that this a bug in Power BI: community.powerbi.com/t5/Desktop/Regression-on-direct-query-over-Streaming-Dataset/td-p/3052320
@@someguynamedchris I am getting the same error. Both the ids that i have checked are same. I am following exactly what you have shown in the video. When i click on Power BI datasets i get the option to select Chat GPT Reply. But as soon as i click on it, i get the same error. Any other alternatives to this?
I am getting the same error too.
Kind of cool, and thanks for sharing, but I did a simply test and submitted 72 numbers in a list and asked it how many numbers were in the list. It said there were 60. I asked it to sort them ascending. It did it. I asked where the number 14 went? It said sorry for the oversight. .... there were many "oversights", so I wouldn't trust this for any analysis if it can't count 72 numbers.
Brilliant work Chris.. keep up... it is of great help dear
This option to set "Power BI data" doesn't appear for me. Is this a problem of licence maybe?
Hey Chris, i got an error on HTTP section so can we connect somehow to support ?
Sorry to you are running into an error, what error are you receiving?
you rock, Chris! brilliant instruction!
Thanks a lot, I appreciate it!
Love this video and have gone through this several times. Ran into the myworkspace issue as described below as well but was able to connect to the dataset in a new workspace. odd for sure. Now I feel like im stuck at a rudimentary step and the button wont click.. the flow is perfect... but cant get the button to run flow.. any ideas?
Hey mark can you tell how you came through that workspace issue ? Still it is saying same thing that database is not exist or you don't have permission
@@m19977 all I did was to go into PBi and ‘create new workspace’ and add the GPT data source in there and then connect to it from the doc.
Hey Mark, glad you enjoy the video! If you are in Power BI Desktop, you'll need to hold the CTRL button down while clicking the button. Once published, the button should be clickable without CTRL.
@@someguynamedchris Ahhhhhh yes. Thats the trick - duh. Thanks for the ping!
Cool - got some of it working - it returned some text : )
Hi Chris, I tried to create flow as I would like to get responses for every row in my database. but I couldn't! do you know how to help with this flow?
RS, are you receiving an error message when creating the flow? Remember, the flow would need to be created and edited through Power BI as it has the additional triggers and actions. You would then be able to see the flow in your My Flows, but not all capabilities would be available. If you'd like, you can send me a screenshot through Facebook messenger; the link to my Facebook profile is on my channel. Thanks!
Wow.. Amazing tutorial. Do you know if it's possible to show a Blank field to allow the end user to write a question to get some insights based on ''his data'' ?
I'm also new in power automate so I'm not sure if you can only set one task per need or it could be more flexible to adress more requirements from just one field in power Automate with gpt.
Hey Joel, thanks for watching. As far as I am aware, there is no user input feature other than dynamic parameters, which I believe are numeric entries. You could write up different text options within a table and do a selection while submitting. I would ensure you can only select a single text option, but once it is selected, you can send that into Power Automate and replace the predefined message with the selection text.
@@someguynamedchris I really like Joels questions, its the same as mine lol.
Looking at this though, If the data model was direct connection to an SQL Table and the Power BI report had an embedded Power App in it, where the user could type out a question, could that field from the streaming data set be used as a dynamic input into PA and Chat GPT ?
@@RelaxingGamingMusic85 You are very much correct, Damien. Using Power BI embedded and having an outside source could work!
power bi for PBI dataset option is not visible at my end and on using power bi dataset from get data, it shows direct query is not available for this dataset. Can someone please help.
Facing the same problem! Were you able to figure out a way to fix this?
The 'content' property of actions of type 'ParseJson' must be valid JSON. The provided value cannot be parsed: 'Unexpected character encountered while parsing value: d. Path '', line 0, position 0.'.
Getting this error.
{
"type": "object",
"properties": {
"id": { "type": "string" },
"object": { "type": "string" },
"created": { "type": "integer" },
"choices": {
"type": "array",
"items": {
"type": "object",
"properties": {
"text": { "type": "string" },
"index": { "type": "integer" },
"logprobs": { "type": "null" },
"finish_reason": { "type": "null" }
}
}
},
"model": { "type": "string" }
}
}
this was the schema.
The JSON is very finicky and must be exact. Trying and use an online JSON parser to find the true issue.
Hey Chris!I followed your steps, however after 15 min running time, i receive following error: Action 'HTTP' failed You exceeded your current quota, please check your plan and billing details. Can i use it without buying openai subscription?
Hey Roman, it appears either your free trial has expired or if you recently signed up, you may not have received a free trial, and you would need to purchase a subscription through OpenAI.
Awesome. Thanks in a million.
Hi chris, i am able to get the answers for general questions from chatgpt, but when i click to add dynamic contents, i am not able to find the option "PowerBI data", What might be the reason.
I am facing the exact same issue. Could you figure out what is wrong, by any chance?
Awesome man thank you so much...
Does somebody know if there is a limit in the size of the data we are asking ChatGPT to analyze?
So the data has to be within the token limit. You'll find more information about your limit at this link under "Managing Conversations" learn.microsoft.com/en-us/azure/cognitive-services/openai/how-to/chatgpt?pivots=programming-language-chat-completions
Guide us how to use chatgpt within Microsoft dynamics 365 especially in finance and operations
Will work on this sometime in 2025. Stay tuned!
Hi Chris,
When I click on "run flow" -> it does not work. :(
Giang, if you are in the desktop, make sure you hold down the CTRL button when clicking on the Run Flow button.
Hope a manual refresh can be avoided and loads analogies etc upon report load itself
Hi Chris - Getting an error from the run history, stating 'Invalid URL (POST /v1/chat/completions)' - Is the model down? (I can list the models via Postman so my key is good) Thanks for everything!
Hey Jimmy, I haven't heard anything about the system being down. If you want me to look at the HTTP step, commenting out the API key, I could see if anything is off. But if it was working previously, I will have to do some additional tests.
You probably have a space at the end of your URL
I get the same error in my flow. Hope anyone can post a solution
This is awesome!
hello, I did all steps but when I apply refresh in the last step to get an answer, I have no answer why (empty box)?
Hi Chis, When I am adding ChatGPTReply from Power BI datasets I get an error. "Value cannot be null. Parameter Name:Data Source". I noticed that others here had the same problem can you help us? thanks.
I solved it, the database name must be the same as the streaming dataset, I advise you to create a new workspace and put the dashboar, the table and the streaming database in the same connection so as not to confuse and redo the process. hugs
I am facing the Authorization (API key ) please tell me
Hey Chris!
thanks a lot for this video, it helps me a lot! It seems chatGPT api (DaVinci) is making lot of error when analysing PowerBI Data using the method you shared. I wonder if that might be due to the data format used (in this case Dynamic content > PowerBI Data). Do you have advices to share table to chatgpt in the best format possible to reduce the risk of error?
Glad the video helps! Unfortunately, I don't have a best practice format for sending in data to ChatGPT. It states it can read tabular data, but I am sure complex formats may be tough. You could potentially try and send in a schema with the data, it may be able to read and utilize the schema to better understand the data.
I think integration with power automate will become much easier in coming days
How so?
Also would like to know how
Great Video Chris, I was wondering if you know how to handle this error. When I am adding the ChatGPTReply from Power BI datasets, I get an error. "Value cannot be null. Parameter name:Data Source". Appreciate the content!
Glad you like the video! What's interesting is that I think I received this error message earlier in the week when trying to overcome the composite issue with the Add to Local Mode, but I don't remember exactly. I'll review my notes and run some tests to see if I can find a solution for you!
Using DirectQuery on datasets from “My workspace” isn't currently supported.
@@someguynamedchris i'm same problem :(
I solved it, the database name must be the same as the streaming dataset, I advise you to create a new workspace and put the dashboar, the table and the streaming database in the same connection so as not to confuse and redo the process. hugs
@@robotics11001001 I'm a bit confused in doing this process. I thought that I named everything the same but is it possible to contact you for some help? I can't seem to figure it out!
Hey Chris, nice demonstration!
I am building a PowerBI custom visual in R like I have done many times, but this time using ChatGPT with Azure-OpenAI.
Do you know how I can get the Dynamic-Content->PowerBI Data inside R Visual, or to provide an idea of retrieving data from report level?
Hey Stavros, I wish I had an answer for you, but unfortunately I do not. I'll keep an eye out, though!
Could you do a video on chatgpt vs tableau as well.
Apologies, RK. I unfortunately do not have Tableau readily available.
@@someguynamedchris Thanks for your response, no problem.
Value cannot be Null. Parameter name : Date source
Getting this error, could you please help me with this?
This is happening when i'm trying to get Power BI Datasets after connection.
After I ran the flow I got the following error message in power automate "'messages' is a required property". has anyone encountered this error
Hey Eduardo, can you please check the URL? That is a message that would be received if your URL is /chat/completion vs. completion.
Amazing
Great video Chris. But I am also facing the same error of adding a streaming dataset as a local model. The other data sets work and streaming does not. Do you have an alternative solution?
Hey Arul, the only alternative solution I can think of would be writing a custom connector for Power BI. If anyone else has a suggestion, feel free to reply!
chatGPT is not very good with math (sometimes even simple calculations). This is an obstacle for data analysis, but he is relatively good at writing code and if the mathematics is done by the code generated by chatGPT we will have more interesting results.
How can we clean the dataset to always have only one Reply?
I haven't tried to clear the dataset. However, the option to not maintain history in the streaming dataset may work. The other option would be to try and add a filter to the grid to only show the latest result. This may take some adjustments to the streaming dataset. Just as an FYI, the current method doesn't work as well as the ChatGPT UI; it doesn't remember the previous questions and answers.
@@someguynamedchristhanks for your response! I put the date on the dataset and worked!
What is your LinkedIn profile link?
Hi John, here's the link: www.linkedin.com/in/some-guy-named-chris-7a0785267/
wow didn't know Alan Garner was a data analyst!
😂😂😂
I think this is good but still a bit far from people's expection. I guess people want to like to see ChatGPT creating, or modifying visuals in Power BI based on a vague free-text instruction from the user?
There is still a lot to be desired, however, with Co-Pilot being introduced (already here), I think Microsoft is going in the direction of more automation.
The guy made me questioning if it is GPT or GTP throughout the whole video.
Cool, but somewhat pointless
Hi Chris... When we are trying to import live dataset "chatgptreply" we are facing the below issue. Could you please help. Thanks.
Feedback Type:
Frown (Error)
Error Message:
Either the database 'ChatGpt Reply' does not exist, or you do not have permissions to access it.
Technical Details:
RootActivityId: 8854c336-28c9-4526-aaeb-f0c3fd000415
Date (UTC): 2/28/2023 6:43:19 AM
Based on the permissions error, it appears that perhaps one user created the Streaming Dataset, while another user is trying to read it from a Workspace. Have you looked at the permissions and ensured the other user has access permissions? If you need additional help, can you please provide the steps you are doing and I might be able to more accurately diagnose the issue.
Any luck?
After further research, it appears that this a bug in Power BI: community.powerbi.com/t5/Desktop/Regression-on-direct-query-over-Streaming-Dataset/td-p/3052320
If you're still facing this issue, here is a tutorial on how to get past this message: th-cam.com/video/8kCN6IA6yck/w-d-xo.html