INSANE AMAZING Power Query tip to quickly change data sources in Power BI and Excel
Vložit
- čas přidán 24. 02. 2021
- If you need to change your data source references in Power Query, you are probably doing them individually. We found an INSANE AMAZING tip to make you way more efficient and it works in Power BI and Excel!
📢 Become a member: guyinacu.be/membership
*******************
Want to take your Power BI skills to the next level? We have training courses available to help you with your journey.
🎓 Guy in a Cube courses: guyinacu.be/courses
*******************
LET'S CONNECT!
*******************
-- / guyinacube
-- / awsaxton
-- / patrickdba
-- / guyinacube
-- / guyinacube
-- guyinacube.com
**Gear**
🛠 Check out my Tools page - guyinacube.com/tools/
#PowerBI #PowerQuery #GuyInACube
This is ideal for switching between test dbs in sql and live ones!
Great trick but has some limitations. For example if you have already parametrized data source via advanced editor(because some data sources doesn't support parameters via UI) it won't allow you to change it via Data source settings
I felt Will Smith teaching us PowerBI 😀
One week too late :'( I manually changed around 240 data sources... Great tip for next time !
No more: "ups, I forgot to change it in THAT one place".
This is legitimately one of the best PQ tips on the internet.
Insane amazing!!!!!
Good tutorial
Super interesting!
Great video... I always use params to point to data sources, that way you can move from dev to uat to production with no pain... Set up the params as a list to make it super smooth.
Hi, amazing video. What I was doing before watching this video is:
+1 more reason you guys are my favorite for learning Power BI. I can't tell you how many times this year alone that you all have taken my Power BI skills to the next level and impressed my boss.
Mindblown lifesawing ayee
Great trick, really helpful, specially for beginners like me. thanks
I spent 3 hours today doing it the manual way and as I’m going to bed, I figured I’d scroll CZcams. Lo and behold, I see this video in my recommendations. As much I wanna cry right now, I’m super excited to try this tomorrow with the remaining queries! Thanks Patrick
I watched this two weeks too late! I just manually updated everything in one of my reports from XLSX to Sharepoint and this would have saved the day! From now on I'm watching your videos as the are published. Can't miss out on any more of these goodies!
I'm a little upset I didn't stumble upon this a month ago. We just went through a server migration and manually updated each connection string with a parameter.... for every single connection in every single report. !!!!!! This would have saved some time! I immediately shared with my team and my client for future reference after I just watched this. Thanks so much!
Hello Genius,
I found this very useful. Saved a lot of stress
I'm this excited too when I'm able to crack a powerbi issue😂 Thanks Patrick