3 HIDDEN tricks in the Power Query editor for Power BI and Excel
Showing off 3 HIDDEN tricks in the Power Query editor, in Power BI and Excel, that you may not have known about. Little things that take Power Query to the NEXT LEVEL!
Power BI community posts… (Roundup | July 6, 2020)
Thanks for watching this week's Power BI news roundup! 2 Minute Tuesday: https://guyinacu.be/userprincipalname Tech video: https://guyinacu.be/whatisrls 📢 Become a member: https://guyinacu.be/membership Sources Why Is Power BI Running My SQL Query Twice? (@cwebb_bi) Analyzing Performance Analyzer trace in DAX Studio (@marcorus) The ultimate button resource for Power BI by Tableau Zen Masters (@curbalen) [...]
How do you get a REFRESH DATE in your Power BI report???
Have you wondered how to get a refresh date in your Power BI report? Adam looks at an easy way to do that with a little Power Query.
Power BI quizzes, data masking and more… (Roundup | June 8, 2020)
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup181 2 Minute Tuesday: https://guyinacu.be/dataflowstricks Patrick's tech video: https://guyinacu.be/synapse Adam's tech video: https://guyinacu.be/pipelines 🔴 Live replay: https://guyinacu.be/live013 📢 Become a member: https://guyinacu.be/membership Sources #3 DAX Fridays! 101: What is Context transition in DAX? (@CurbalEN) How To Mask Sensitive Data In [...]
Lots of Power BI community posts… (Roundup | May 18, 2020)
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup179 2 Minute Tuesday: https://guyinacu.be/copyquery Patrick's tech video: https://guyinacu.be/datepicker Adam's tech video: https://guyinacu.be/matrixkpis 🔴 Live Replay: https://guyinacu.be/35WURjU 📢 Become a member: https://guyinacu.be/membership Sources Speed Up Data Refresh Performance In Power BI Desktop Using Table.View (@cwebb_bi) Part 3: Reflections on Excel [...]
Copy queries in Power Query for Power BI or Excel
Did you know you could copy queries, in Power Query, between Power BI or Excel files? Even Notepad? Patrick shows you how, and more...
What to do when your Power BI dataflows data source isn’t listed???
Are you trying to use Power BI dataflows, but your data source isn't listed? We show you an option you can try to get things running!
Create custom keys for your Power BI relationships
Enough of these single table models! Model your data and create custom keys within Power BI to make your reports more efficient! Download Sample
Do you know what a Power BI seed file is??? (Roundup | Jan 27, 2020)
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup164 2 Minute Tuesday: https://guyinacu.be/qandatooling Patrick's tech video: https://guyinacu.be/copyreports Adam's tech video: https://guyinacu.be/pbiworkemail Sources Easily Build Great User Experiences In Power BI (Chris Wagner) GET STARTED WITH POWER BI (@marqueeinsights) Dual Axis Line Chart in Power BI (@ExceleratorBI) 6 DAX [...]
Is Query Folding happening in Power BI?
We look at how to tell if query folding is actually happening within Power BI. You may be surprised! Power Query has a few tools for you. Download sample