Power BI Weekly Issue 118: 13th July 2021
No announcements whatsoever this week, but plenty of great content elsewhere. Dennes Torres has described how to Embed Power BI in Jupyter Notebooks, explaining their opinion on the current usefulness of the feature. Nikola Ilic has described everything you need to know about thePaginated Report visual, digging into the internals on how the visual is working. Finally, Philipp Lenz has written a succinct blog describing What you can do with Power BI and perspectives, and Gilbert Quevauvilliers has continued the series around Migrating AAS to PPU - this time sharing some insights regarding Historical Data Loading.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Patrick Leblanc (@GuyInACube) explains how to Create Buckets or Groups with Power Query in Power BI
- Antriksh Sharma explains how to Remove Characters from a String in Power Query with M Code Power Query Tutorial
- Arnaud Gastelblum (@LazySna1l) blogs about Power BI - Create a Calendar table automatically
- Parker Stevens (@PowerBIElite) highlights the Easiest Way to Get Microsoft Forms Data in Power BI
- Soheil Bakhshi (@biinsightnz) blogs about Integrating and Visualising Multiple Microsoft To Do Accounts with Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Reverse cumulative values in Power Query
- Pat Mahoney (@HoosierBi) describes How to Create and Modify Custom Functions in Power BI or Excel
- On the Power BI Community blog, Sam Zha writes about The step between python process and M engine drops leading zeros
- Sam Fischer (@ApexInsightsPBI) describes how to Convert a date range to a list of dates with Power Query and describes Dealing with Gaps and Islands in Power Query
- Bas Dohmen (@HowToPowerBI) talks about CSV Import in Power BI
- Mike Allen (@MikeAinOz) blogs about Planner Reporting Increment 8 - technical notes
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Optimizing conditions involving blank values in DAX, discusses GROUPBY, CURRENTGROUP – DAX Guide and talks about FILTERS – DAX Guide
- Antriksh Sharma talks about Blank Row and Table Functions in DAX
- Philipp Lenz (@lenz_philipp) writes about What can you do with Power BI and perspectives?
- Sam McKay (@_EnterpriseDNA) talks about Data Model Development Best Practices In Power BI
- On the Enterprise DNA blog, Jarrett Moore (@BuckeyeJarrett) shares a few blogs: Power BI Data Transformation and Setting Up Models and Relationships, Building Power BI Reports: Organizing DAX Measures & Page Development and Use Measure Branching To Speed Up Report Development
- Hima Bindu Marri (@sivahimabindu) talks about % of Parent Row in Power BI
- Meagan Longoria (@mmarie) describes Calculating Age in Power BI
- On the Towards Data Science blog, Jenna Eagleson (@JennaEagleson) discusses Power BI Tips & Tricks: Custom Sort
- Chandeep Chhabra (@chandeep2786) describes how to get the Sum of Max Values in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Enterprise DNA blog, Mudassir Ali shares a few blogs: Small Multiples Chart In Power BI: An Overview, Anomaly Detection In Power BI: Options And Limitations and Power BI Dashboard Designs: Visuals And Effects
- Reid Havens (@HavensBI) highlights the New Features for Modern Visual Tooltips
- Bas Dohmen (@HowToPowerBI) talks about the Modern Tooltip in Power BI and explains how to Create a Target Area for a Line Chart in Power BI | No Custom Visual
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes about the Paginated Report visual in Power BI—everything you need to know
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about the Power BI Filter pane | Customize the Color Font and Style
- Amanda Rivera (@MissAmandaN) explains how to Create quick reports in Microsoft Power BI on the web
- On the SQL Server Central blog, Dennes Torres (@Dennes) explains how to Embed Power BI in Jupyter Notebooks
- Rick de Groot (@Rickmaurinus) describes Creating a Custom Filter Panel in Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Chris Webb (@cwebb_bi) writes about Power BI Dataset Refresh, Column Encoding And The First Partition
- Gilbert Quevauvilliers (@GilbertQue) writes about Historical Data Loading – Part 5 – Migrating AAS to PPU
- Dhruvin Shah (@DhruvinShah16) talks about XMLA End Points in Power BI with Abhinav Singh
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) describes how to Create readonly DB user in Azure SQL DB for Power BI
- Reid Havens (@HavensBI) blogs about Getting to know Power BI Template Apps (AppSource) with Teddy Bercovitz
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 198 - Interview with Treb Gatte
- On the SQL Server Central blog, Sucharita Das provides An Introduction to Power BI
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (July 10, 2021)
- On the Power BI Community blog, Fowmy Abdulmuttalib (@ExcelFort) describes How I Prepared and Successfully Passed the DA-100 Microsoft Exam
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.