We have usually said that if you use a native query, you break query folding in Power Query. Interesting. There may be a way to enable it in Power BI! Patrick shows you how. Chris Webb Blog: https://blog.crossjoin.co.uk/2021/02/21/query-folding-on-sql-queries-in-power-query-using-value-nativequery-and-enablefoldingtrue/ Query folding guidance in Power BI Desktop https://docs.microsoft.com/power-bi/guidance/power-query-folding Visualise your Power BI Refresh https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
By default, your DirectQuery queries, in Power BI, will send a LEFT OUTER JOIN and could make your DBA not happy! Patrick shows you how you can change this to an INNER JOIN and put your DBA back into that happy space.
Can we use source control with Power BI? We get this question ALL THE TIME! Adam walks you through what your options are and how this works today with Power BI. ALM Toolkit: http://alm-toolkit.com/ Tabular Editor: https://tabulareditor.com/ Latest updates for Deployment Pipelines: https://powerbi.microsoft.com/blog/announcing-new-deployment-pipelines-capabilities/ Source Control Idea https://ideas.powerbi.com/ideas/idea/?ideaid=c73d887d-042e-4ca0-8216-bcb09bd282ab
Automate data driven subscriptions with the Power Platform using Power BI and Power Automate! Patrick shows you how to quickly setup a report bursting option for your reports.
Join us live as we answer your questions about Power BI! With special guest, Kasper de Jonge! Connect with Kasper: Twitter: https://twitter.com/Kjonge YouTube: https://www.youtube.com/channel/UC40_DLjKbvxkhMc7N4UevkA Website: https://www.kasperonbi.com/ 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" [...]
Have we found the best kept SECRET in Power BI? Adam saw this recently and was BLOWN away! Zooming in can help with presenting in business settings and anywhere else. Here are a few things you can use to make that presentation better with Power BI. ZoomIt: https://docs.microsoft.com/sysinternals/downloads/zoomit DAX Studio: https://daxstudio.org/
Do you want to highlight your top or bottom values dynamically in Power BI? Patrick looks at a creative way to accomplish this using WHAT IF parameters. Download Sample
Let's keep the big data discussion going with Power BI and the folks from SQLBI - Marco & Alberto! Connect with SQLBI: Website: https://sqlbi.com YouTube: https://www.youtube.com/sqlbi Marco Russo: https://twitter.com/marcorus Alberto Ferrari: https://twitter.com/FerrariAlberto 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats [...]
goes through the options to help you master bookmarks! Taking your reports to the next level! Bookmark Documentation: https://docs.microsoft.com/power-bi/create-reports/desktop-bookmarks Download Sample
Join us live as we answer your questions about Power BI! With special guest, Matthew Roche! Connect with Matthew: Twitter: https://twitter.com/SQLAllFather YouTube: https://www.youtube.com/channel/UCpsilPn-2qFlrYYuvyFkpPQ Website: https://ssbipolar.com/ 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in [...]