This is awesome! I took an old file I built nearly two years ago when I was relatively new to Power Query and it was hard for me to decipher what I had done. Not only did is comment everything, it simplified the code into fewer steps
Wow, LOVE this! I am definitely going to play with it! Yes, would love to see more prompts for both Power query and PBI👍. Thanks for sharing the work you’ve done to figure this out - it will save a great deal of time!
Hi Wyn. Just signed up for Chat GPT4 (Plus). Gave it a Power BI measure creation problem to solve that was a little bit tricky. Did it in seconds flat! As you are, I'm in total awe of this tool.
Thanks for sharing your experience. What is impressing me more and more is the simplicity of iterating through different solutions and prompting for corrections when solutions don't quite work. It feels so natural that I'm almost taking it for granted now.
Thanks very much Wyn! I tried this with Chat GPT 3.5 and it worked well. I need to give you all the credit for the prompt. I'm enjoying your videos for analytics + GPT 😀
Thanks a million for sharing this - worked a charm when I tested it at work today, even after editing your prompt to translate the result to Swedish. Genuinely appreciate it!
Seen this video some time ago and wanted to give it a try. What I obtain with ChatGPT 3.5 is really good. With Bing Chat AI I'm stuck by the limit of 4000 characters. With Bard the result is a mess: many let and in ! Great great thx Wyn 😀
This is a fantastic tip, but there may be free alternatives. Bing Chat AI uses GPT-4, so you should be able to get identical results from Bing for free (as long as you are using Microsoft Edge, but availability is supposed to be expanded to other browsers eventually). In the longer term, Copilot for Excel and/or Power BI may provide this same capability, although I haven't seen it demonstrated in Power Query or seen any indication of how much it might cost. Thanks again for the great content.
Good suggestion, I have tried with bing and it gave the wrong result and didn’t actually finish the code. It will eventually be built in im sure. Exciting times !
Great tip! I normally use the free ChatGPT, optimize the code with comments, and then copy and paste the M code to let the magic happen. Sometimes it gives me the right code, and sometimes it doesn't work.
This is great stuff! Thank you so much! How many characters will the Chat GPT allow for an inquiry? Bing Chat allows for 2,000. I have a query that has 5,400 characters in M code.
Hi, the prompt is in the link and you can apply to any code. I do have the Gym Membership source data here if you want to apply your own PQ steps to some dummy data. pbi.guide/resources/#PracticeData
AI is marvelous. It really can do magic. At the same time, I am quite skeptical that comments generated by AI bring much value. When do I comment my code and why? I comment only those parts that I know for sure at some time in the future will be difficult to recall what I was thinking about while writing the code. It is highly important not only to make comments but to do it myself. When comments are made by my brain, then it’s highly likely that later my brain will manage to retrieve my memories on the subject with ease. Only my notes/comments can trigger and bring up my recollections. Yeah, the message that comments convey is important by itself, but no less is important for me to be the comments author. At least for me it is so.
Fair enough. It’s good to consider the future users/owners of your reports too. For me this is a great reminder and I always read the code and descriptions to confirm accuracy which helps re-enforce my memory.
Still, future users can also ask Chatgpt for comments. I think it might be more usefull to add some whys to the code, explaining why you wrote it in a certain way. And leave the hows to chatgpt
It would be so nice if AI were only used as a tool to support the development of the individual, as you demonstrate here. Unfortunately that is not the way. Man loves to dwell and peer into the abyss. One day we will fall, if we are not already falling. Documentation has always been something that developers have greatly underestimated. It's boring and it's hugely time-consuming. Congratulations on the excellent presentation. It would be great if you would share your prompt with us.
This is awesome! I took an old file I built nearly two years ago when I was relatively new to Power Query and it was hard for me to decipher what I had done. Not only did is comment everything, it simplified the code into fewer steps
Brilliant!
This is huge- helps with business continuity. Everyone hates picking up someone else’s sloppy files!
Absolutely !
Wow, LOVE this! I am definitely going to play with it! Yes, would love to see more prompts for both Power query and PBI👍. Thanks for sharing the work you’ve done to figure this out - it will save a great deal of time!
You’re very welcome. I appreciate you taking the time to let me know you found it useful
Nice prompt including examples and suggestion in new query. Thanks. Very useful!
You're welcome, thanks for taking the time to leave a comment and let me know it was useful.
Hi Wyn. Just signed up for Chat GPT4 (Plus). Gave it a Power BI measure creation problem to solve that was a little bit tricky. Did it in seconds flat! As you are, I'm in total awe of this tool.
Thanks for sharing your experience. What is impressing me more and more is the simplicity of iterating through different solutions and prompting for corrections when solutions don't quite work. It feels so natural that I'm almost taking it for granted now.
Excellent prompt, thank you so much for sharing!!!
You’re welcome
Brilliant! I'm on it! Thanks a million
Best of luck!
Great stuff, super useful once again, Wyn!!!!
You’re welcome
Thanks very much Wyn! I tried this with Chat GPT 3.5 and it worked well. I need to give you all the credit for the prompt. I'm enjoying your videos for analytics + GPT 😀
Great, glad it worked for you. Thanks!
Thanks a million for sharing this - worked a charm when I tested it at work today, even after editing your prompt to translate the result to Swedish. Genuinely appreciate it!
Great to know. I appreciate you taking the time to let me know you found it useful
Awesome video and thanks for sharing the prompt!
You're welcome Hannah
Seen this video some time ago and wanted to give it a try. What I obtain with ChatGPT 3.5 is really good. With Bing Chat AI I'm stuck by the limit of 4000 characters. With Bard the result is a mess: many let and in ! Great great thx Wyn 😀
Great, the future starts here!
Amazing! Great content! Thanks for sharing! This one video will exponentially help so many Power Query uses create better code!
Thanks Joseph. It’s pretty exciting
This is great! Yes, if you could please make a example of documenting with DAX would be super useful. Great channel!!
Cheers Álvaro
This is a real-time saver. 👍
Cheers
Pretty cool. Great content
Cheers
Spectacular, very useful...🤯...thanks for sharing¡¡¡¡
You’re welcome 😃
Thanks for sharing. Very interesting and usefull!
Cheers Claude, you're welcome
Great example
Cheers Justin
Hi Wyn thanks. Have you compared GPT to Bard for this example?
No, I haven’t used Bard Michael
This is a fantastic tip, but there may be free alternatives. Bing Chat AI uses GPT-4, so you should be able to get identical results from Bing for free (as long as you are using Microsoft Edge, but availability is supposed to be expanded to other browsers eventually). In the longer term, Copilot for Excel and/or Power BI may provide this same capability, although I haven't seen it demonstrated in Power Query or seen any indication of how much it might cost. Thanks again for the great content.
Good suggestion, I have tried with bing and it gave the wrong result and didn’t actually finish the code.
It will eventually be built in im sure. Exciting times !
Great tip! I normally use the free ChatGPT, optimize the code with comments, and then copy and paste the M code to let the magic happen. Sometimes it gives me the right code, and sometimes it doesn't work.
Thanks, I've had very limited success with the free version. The paid version is amazing.
Would you create similar prompt to do such with excel VBA codes?
Absolutely. We’re already doing that.
Has it ever altered the outcome of your formula, despite you telling it not to? Thanks!
Not yet but I always check my code afterwards to make sure
This is great! Please share the prompt.
Thanks, the link is in the description
This is great stuff! Thank you so much! How many characters will the Chat GPT allow for an inquiry? Bing Chat allows for 2,000. I have a query that has 5,400 characters in M code.
nvm. I just found the answer using the Google thingy.
Cheers
Hi Wyn, great video. Love it!! I would love to download your excel file and replicate the steps taken in this video. Is this possible?? Thanks!!
Hi, the prompt is in the link and you can apply to any code. I do have the Gym Membership source data here if you want to apply your own PQ steps to some dummy data. pbi.guide/resources/#PracticeData
What’s the prompt you used?
The link to it is in the description
Hello , as you have done this project already , please i wanna know , how did you get that speech to text qa feature into your app?
Not sure what you are referring too sorry
I'm talking about the power bi app that can visualise data just with voice
Ah, that’s just built in functionality if you have a Dashboard and open it in the Power BI app
AI is marvelous. It really can do magic. At the same time, I am quite skeptical that comments generated by AI bring much value. When do I comment my code and why? I comment only those parts that I know for sure at some time in the future will be difficult to recall what I was thinking about while writing the code. It is highly important not only to make comments but to do it myself. When comments are made by my brain, then it’s highly likely that later my brain will manage to retrieve my memories on the subject with ease. Only my notes/comments can trigger and bring up my recollections. Yeah, the message that comments convey is important by itself, but no less is important for me to be the comments author. At least for me it is so.
Fair enough. It’s good to consider the future users/owners of your reports too. For me this is a great reminder and I always read the code and descriptions to confirm accuracy which helps re-enforce my memory.
Still, future users can also ask Chatgpt for comments. I think it might be more usefull to add some whys to the code, explaining why you wrote it in a certain way. And leave the hows to chatgpt
what is Camelcase? I'm no native english speaker
😀 🐫 PhrasesWithBumps
It would be so nice if AI were only used as a tool to support the development of the individual, as you demonstrate here.
Unfortunately that is not the way. Man loves to dwell and peer into the abyss. One day we will fall, if we are not already falling.
Documentation has always been something that developers have greatly underestimated. It's boring and it's hugely time-consuming.
Congratulations on the excellent presentation.
It would be great if you would share your prompt with us.
Hi, link is in the description. Cheers