Switch a Power BI Report’s dataset without needing Premium!
Want a dev and production environment in Power BI but don't have Power BI Premium? Patrick shows you a way to switch a report from Dev to Production without Premium or without APIs.
🔴 Power BI Adoption and More Q&A with Melissa Coates and Matthew Roche!
Join us live as we answer your questions about Power BI Adoption and more with special guests, Melissa Coates and Matthew Roche! 📢 RULES FOR Q&A: 📢 👉 Put a "Q:" in front of your comment to help us identify questions! 👉 Super chats take priority 👉 Do NOT re-post your questions! We'll get to [...]
Visually see where you BROKE the fold in Power Query
Rule #1 - DON'T BREAK THE FOLD! There is an amazing feature that lets you see where this fold was broken, and I'm guessing you didn't even know it was there! Adam shows you where to go. Query plan for Power Query (Preview) https://learn.microsoft.com/power-query/query-plan
Checking out the new Power BI RLS Editor
Take a look at the new Row-Level Security (RLS) editor within Power BI Desktop! Patrick explores how it works and what to look out for in the Preview. Power BI February 2023 Feature Summary https://powerbi.microsoft.com/en-us/blog/power-bi-february-2023-feature-summary/ Documentation https://learn.microsoft.com/power-bi/enterprise/service-admin-rls#define-roles-and-rules-in-power-bi-desktop-using-enhanced-row-level-security-editor-preview
What’s a JUNK DIMENSION and when should you use it?
Maybe you've heard of the concept of a junk dimension but what exactly is it and when should you use it? Patrick breaks down this dimensional modeling concept. Junk Dimensions https://www.kimballgroup.com/data-warehouse-business-intelligence-resources/kimball-techniques/dimensional-modeling-techniques/junk-dimension/ Design Tip #113 Creating, Using, and Maintaining Junk Dimensions https://www.kimballgroup.com/2009/06/design-tip-113-creating-using-and-maintaining-junk-dimensions/ Sample Script: https://github.com/guyinacube/demo-files/blob/master/video%20demos/Synapse/20230321%20-%20Junk%20Dimension.sql
How do THIN reports work with Power BI Deployment Pipelines?
Using Power BI Deployment Pipelines and curious what happens when the report and dataset are in different workspaces? How does it work when you promote to another pipeline? Kevin Arnold shows us! Kevin Arnold: https://twitter.com/kevarnold https://www.linkedin.com/in/kevarnold/
Art of the Possible with Power Platform and Azure Synapse
What happens when you combine Power BI, Power Apps and Azure Synapse Analytics? MAGIC! Join Gaston Cruz as he shows a way to bring the Power Platform together with Azure Synapse! Gaston Cruz https://twitter.com/GastonFCruz https://www.linkedin.com/in/gastoncruz/
Dataset permissions required for App report in Power BI? What am I missing???
Struggling with Power BI App permissions when using shared datasets? Adam looks at how this works. Even for PRO users!!! Composit model permission blog (Older information): https://powerbi.microsoft.com/en-us/blog/update-to-required-permissions-when-using-composite-models-on-a-power-bi-dataset/
The MAGIC of Microsoft Teams + Power BI
Are you using Power BI within Microsoft Teams? Daniel joins us to show the possibility of leveraging Microsoft Teams and the different ways to use Power BI. Announcing – Embed your Power BI organizational apps in Microsoft Teams Channels and Meetings https://powerbi.microsoft.com/en-us/blog/announcing-embed-your-power-bi-organizational-apps-in-microsoft-teams-channels-and-meetings/ Daniel Glenn: https://twitter.com/DanielGlenn https://www.linkedin.com/in/danielglenn/ https://365mcs.com/ https://www.youtube.com/365mcs
Getting Crazy with the Power Query UI
Using Merge statements? Alex shows you how that can break the fold in Power Query! He's got you covered though and shows you a different way to approach it to make folding work! Using the UI! Alex Powers: https://twitter.com/notaboutthecell https://www.linkedin.com/in/alexmpowers/ https://itsnotaboutthecell.com/