Power BI Weekly
Issue #136 - 14th December 2021
This week: we've been shown how to use the new (preview) visualization feature within Dataverse that allows you to quickly analyze your Power Apps and Dynamics 365 data, we've been told that the Power BI app for Microsoft Teams is now available in the US Government Community cloud, and we've been told that the CustomData feature (previously only available for SSAS/AAS) is now generally available in Power BI.
Most of us know about the concept of using bridge tables to model many-many relationships, but Alberto Ferrari has written about an alternative option to model many-to-many relationships in Power BI and Tabular, making use of the single direction many-many support offered in Power BI. As ever, there is no "one size fits all" guidance, but it's an interesting modeling strategy to consider. Paul Turley has written a follow-up blog about Composite Models Using DirectQuery Over Power BI Datasets, evaluating how far the feature has come since it was first revealed a year ago. Finally, Matthew Roche has written an interesting article about Rebranding Data Governance, highlighting the negative connotations behind the term and how best to change the perceptions/rebrand it.
🛠️ Data Prep
- Chris Webb (@cwebb_bi) discusses Troubleshooting Power BI Timeouts, Part 2: Timeouts Specified In Power Query Functions
- Adam Saxton (@GuyInACube) asks Are you using the right Dataflows connector in Power BI?
- Lars Schreiber (@SchreiberLars) discusses Loading multivalued fields from Microsoft Access – not possible with Power Query
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shows Getting Multiple Lookup Values in One Cell | Power Query
- Rick de Groot (@Rickmaurinus) writes about 4 Ways to Create Date Column for a Calendar in Power Query and explains How to Use List Generate to Make API calls in Power Query
🧩 Data Modeling
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about Different options to model many-to-many relationships in Power BI and Tabular, describes FACT – DAX Guide and describes RELATED, RELATEDTABLE – DAX Guide
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes how to Boost Power BI performance by improving cardinality levels
- On the Power BI Tips and Tricks blog, Greg Baldini (@GregBaldini) writes about All Columns have Data Types in DAX, Or do they?
- Paul Turley (@paul_turley) wonders Are We There Yet? …Composite Models Using DirectQuery Over Power BI Datasets
- On the SQL Server Central blog, Adam Aspin provides an Introduction to DAX for paginated reports
- Leila Gharani (@LeilaGharani) shares DAX CALCULATE Function Made Easy to Understand (just one word)
- On the Learning Science YouTube channel, Learning Science talks about the COUNTROW, COUNT, COUNTBLANK, DISTINCTCOUNT, DISTINCTCOUNTNOBLANK & COUNTA Functions in Power BI
- Bernat Agulló (@AgulloBernat) blogs about Calculating the percentage of targets reached
- Brian Julius talks about What Are "Junk Dimensions" And Why They're Anything But Junk - Power BI Data Modeling Pro Technique
- Antriksh Sharma (@AntrikshShar) describes Using Multiple Columns with IN Condition in DAX
📊 Report Authoring and Interactivity
- On the Power BI blog, Amanda Rivera (@MissAmandaN) explains how to Visualize your data quickly from Power Apps and Dynamics 365 apps (preview)
- Patrick Leblanc (@GuyInACube) describes how to Use Bookmark Navigator in Power BI to easily move through Bookmarks
- Matthew Peterson (@mattpetersonbi) talks about the Power BI: New Bookmark Functionality
- Bas Dohmen (@HowToPowerBI) describes the Custom Period Slicer in Power BI
- Reid Havens (@HavensBI) talks about Dynamic Font Color Logic with Conditional Formatting in Power BI
- Chandeep Chhabra (@chandeep2786) describes how to Highlight Missed Targets in a Line Chart
- Philipp Lenz (@lenz_philipp) explains how to Add comments to Power BI Visuals and the data by using Analysis Services Cubes
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) writes about Power BI Goals : Maintenant pour les détenteurs de licence Pro [French]
🚀 Deployment, Security and Operations
- On the Power BI blog, Ogbemi Ekwejunor-Etchie highlights that The CustomData feature is now generally available in Power BI
- David Eldersveld (@dataveld) writes about Microsoft 365 E5 and the Case of the Missing Power BI Pro
- On the CSG Pro blog, Simi Talkar explains How to Call Power BI REST APIs with Custom Connector and Postman
- Gilbert Quevauvilliers (@GilbertQue) discusses Power BI Premium/Premium Per User – Automating Processing of historical partitions
- On the SQL Shack blog, Aveek Das (@avikoleum) provides An overview of Power BI Incremental Refresh
- On the Tessellation Tech blog, Ryan Lurquin describes How and When to Use Power BI Row-Level Security
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to Import Azure Active Directory Users into Power BI; A Step toward Dynamic Row-Level Security
- On the Power BI Community blog, Henry Kong describes how to Get historical refresh records for all datasets within organization via PowerShell
- Matthew Roche (@SQLAllFather) talks about Rebranding Data Governance
🌐 General
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) shares Announcing: The Power BI app for Microsoft Teams is now available in the US Government Community cloud
- The Power BI team (@MSPowerBI) explains how to Explore Power BI as a core capability in Microsoft Teams
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a Power BI Sample Dashboard Using Logistics Data
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) shares the talk: Data Culture with Matthew Roche
- Reid Havens (@HavensBI) discusses Driving a Data Culture with Power BI (with Tommy Puglia)
- Also on the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) discusses Measuring Data Culture Success
- On the RADACAD blog, Reza Rad (@Rad_Reza) blogs about the Skills Needed for a Power BI Developer
- On the Burningsuit blog, Stuart Box (@StuartBox) shares Strictly Come Dancing Power BI analysis
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Dec 11, 2021)