2 Power Query Refresh Secrets Everyone Should Know!
Vložit
- čas přidán 30. 07. 2024
- In this video learn how to effortlessly refresh your queries in Power Query with just the latest data and how to prevent your files from being overwritten so that you’re not losing valuable insights when you hit refresh.
Please download the practice file here: drive.google.com/drive/folder...
Matt Allington's blog: exceleratorbi.com.au/self-ref...
✅ If you would like to connect on LinkedIn:
🤝 www.linkedin.com/in/missmicrosoft
✅ If you would like to support the channel by buying me a coffee, (it's really quick and easy), please use this link:
☕www.buymeacoffee.com/missmicr...
✅ For more videos please subscribe:
🔔 / @missmicrosoft
00:00 Example 1
02:29 Example 2
Be among the first 100 to jump on board "The Query Editor" newsletter 🚀. It's packed with super-actionable tips and insights. Why should you be excited? 🌟 Because the first 100 subscribers will receive an exclusive 50% discount on my upcoming mini-course, set to drop early next year (or perhaps even sooner)! 🤞Just hit this link to subscribe thequeryeditor.beehiiv.com/subscribe
🚀🔥
You are great!!!! Subscribed
Very interesting! Is it also possible to do the second example in Power BI? In there I don't have the option to get the data from table/range and you can't load it load it to connection only?
Superb! Looking forward for more videos like this
Thank you! I will do my best 😊
Thanks Miss
I love your vidéos.. keep going
Thank you, I'm so glad the videos are helpful!
Great tips ! Thank you for sharing 😊
You are so welcome!
Excellent!
Thank you 😊
Interesting stuff. Before watching this, I would have been nervous about trying something like Example 2. I might have expected an error message like when you write an Excel formula with a circular reference.
Glad you enjoyed the video! Example 2 won’t have a circular reference as we’re referencing the table in the sheet and not the query itself.
I am trying to utilize the first trick with regard to temporary files. When I have my working files open I am still not able to refresh. Is there something I am doing wrong? I really have learned a lot from your videos and appreciate the content very much!!
In first exemple, give error, the key don t correspond any line of table. Any ideia for error? Thank