Join us live as we answer your questions about Power BI! 💥 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 front of your comment to help us identify questions! 👉 Super chats take priority [...]
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!
Are you using a flat table in your Power BI report? You may be missing out! Patrick explores what a STAR SCHEMA is and why you should be using it. Guidance doc: https://docs.microsoft.com/power-bi/guidance/star-schema DAX.tips: https://dax.tips/2021/02/15/visualise-your-power-bi-refresh/
Do you work on your Power BI dataset or data model? Are you following best practices? Patrick walks you through a best practice analyzer set for Tabular Editor, from Michael Kolvasky, that can help you improve your data model. Blog post: https://powerbi.microsoft.com/blog/best-practice-rules-to-improve-your-models-performance/ Tabular Editor: https://tabulareditor.com/ Download BPA Rules: https://github.com/microsoft/Analysis-Services/tree/master/BestPracticeRules Michael Kolvasky's Blog: https://www.elegantbi.com/ Feedback: pbibestpractice@microsoft.com
Do you have slowly changing dimensions in your Power BI dataset? Struggling to work with them to get the right values? Patrick walks you through how you can deal with them. Wikipedia https://en.wikipedia.org/wiki/Slowly_changing_dimension Using calculation groups to switch between different dates (SQLBI) https://www.youtube.com/watch?v=kilQrRR04mY P3 - https://powerpivotpro.com/2019/06/how-can-i-get-a-lookup-table-from-a-slowly-changing-dimension-scd/ Download Sample
Join us live as we answer your questions about Power BI! 📢 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 as many questions as we can. 👉 If you SPAM your [...]
In this video, we look at Power BI for report consumers, or end users. Those folks that maybe don't author reports, but just view reports within Power BI. We introduce some basic Power BI concepts and introduce you to areas of the Power BI service to get you familiar with the portal. Documentation: https://docs.microsoft.com/power-bi/consumer/
You've got multiple fact tables in your Power BI dataset. And, dimension tables for each. Struggling to slice and dice across both? Patrick shows you how to deal with this mess. Understand star schema and the importance for Power BI https://docs.microsoft.com/power-bi/guidance/star-schema
Join us live as we answer your questions about Power BI! 💥 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 front of your comment to help us identify questions! 👉 Super chats take priority [...]
There is a new Power BI Embedded sample application called Contoso Sales. The best part? The source code is available out on GitHub! Adam walks you through the sample application. Contoso Sales Embedded Demo GitHub Repo https://github.com/microsoft/Power-BI-Embedded-Contoso-Sales-Demo Contoso Sales Embedded Demo https://contososalesdemo.azurewebsites.net/ Old Warehouse embedded demo (logins are embedded on the sign in page - [...]
