We talk about optimizations a LOT! We pile onto a question posed by Chris Webb - Should you optimize for CPU in Power BI? We think the answer is YES! Let's explain... Chris Webb's Blog: https://blog.crossjoin.co.uk/2021/09/19/why-you-should-optimise-your-power-bi-premium-reports-and-refreshes-for-cpu-time-as-well-as-duration/ 3 signs it's time to OPTIMIZE your Power BI report https://www.youtube.com/watch?v=uKSkMDEGM2I
Have you struggled with using Row-Level Security (RLS) on a dimension connected to two fact tables? Patrick looks at some options you can use to accomplish this in Power BI.
Join us live as we answer your questions about Power BI with special guest Alberto Ferrari from SQLBI! 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 💥 30 minutes: Open Q&A (Public) 💥 Then... Members Only Chat (Public can watch & Super Chat for Questions) 📢 RULES FOR Q&A: [...]
Another question from the comments... MrTavelBlog wanted to know how to show 5 minute intervals in Power BI. Patrick accepts the challenge and shows you how! Power BI date table: create using DAX https://www.youtube.com/watch?v=gyvhM5eiT0U Working with time in Power BI Desktop https://www.youtube.com/watch?v=8DFih8ccMV0 Create Buckets or Groups with Power Query in Power BI https://www.youtube.com/watch?v=D1LO8syugMA