Power BI Weekly Issue 142: 1st February 2022
A few updates this week, the first being the Power BI Report Server January 2022 Feature Summary with some of the recent bookmark updates landing, along with with some of the DAX updates that landed a couple of months ago for "mainstream" Power BI Desktop. We've also been given a reminder that WebView2 will be required for the next Power BI Desktop release, and we've been told how to Optimize your Processes and Gain Deep Insights with Process Mining, which isn't directly related to Power BI (other than the fact it utilizes Power BI Embedded), but it's a pretty cool feature to know about nonetheless.
Elsewhere this week, Reza Rad has reminded us how we can achieve a Power BI Sandbox: An Environment to Learn Power BI Service for Free, Matija Kocevar has written a detailed post about How to choose the correct chart type for your Power BI report and Adam Saxton has described How Parameters work with the Power BI Paginated Visual.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Gašper Kamenšek (@ExcelUnplugged) blogs about Data Types – Part 1 – Create Your Own Data Types in Power Query
- James Andrew covers Creating Absolute Values within Power Query Custom Columns
- Ruth Pozuelo Martinez (@CurbalEN) blogs about The best way to combine files in Power BI so you don't lose columns
- Gaelim Holland talks about Using Python Sentiment Analysis
- Hima Bindu Marri (@sivahimabindu) covers Parameterization of data sources in Power BI
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) talks about the Performance of sparklines in Power BI – Unplugged #41, and shares a few tutorials: GCD, LCM – DAX Guide, EXPON.DIST – DAX Guide and FLOOR, MROUND, CEILING, ISO CEILING – DAX Guide
- Brian Julius (@_EnterpriseDNA) describes How To Create Self-sorting Columns In Power BI
- Daniil Maslyuk (@DMaslyuk) covers Power BI Antipatterns 2: SELECTEDVALUE
- Arnaud Gastelblum (@LazySna1l) writes about 'DAX is case insensitive'
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Zebra BI site, Matija Kocevar describes How to choose the correct chart type for your Power BI report
- Fowmy Abdulmuttalib (@ExcelFort) describes How to Make a Pareto Chart in Power BI Step-By-Step Tutorial - Part 1 and Pareto Chart with ties In Power BI - Step-By-Step Tutorial - Part 2
- Ruth Pozuelo Martinez (@CurbalEN) describes How to add annotations to a chart in Power BI to provide an explanation or more context
- On the Tessellation Tech blog, Gavin Pedersen explains How to Make the Most of Power BI Tooltips
- Adam Saxton (@GuyInACube) describes How Parameters work with the Power BI Paginated Visual and explains how to Create a date range parameter with Power BI Paginated Reports
- Also on the Tessellation Tech blog, Spencer Baucke (@JSBaucke) blogs about Optimizing Power BI Reports
- James Andrew describes how to Dynamically Highlight Column Values Within Power BI Using DAX & Conditional Formatting
- On the Perficient blog, Vaibhav Punwatkar explains how to Hide and Show Slicer Pane in Power BI Desktop
- On the Data Bear blog, Annamarie Van Wyk (@annamarie_wyk) writes about 3 Ways with Slicers in Power BI
- Bas Dohmen (@HowToPowerBI) explains how to Embed Images in Power BI and describes a Power BI Write Back Option with Power Apps
- On the RADACAD YouTube channel, Rui Romano (@RuiRomano) talks about Power BI Development on Steroids
- Also on LaDataWeb, Pablo Deheza writes Formato Condicional para Grafico de Líneas [Spanish]
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares a Reminder: WebView2 will be required for the next Power BI Desktop release and explains how to Collect diagnostic information for Power BI
- On the RADACAD blog, Reza Rad (@Rad_Reza) describes how to create a Power BI Sandbox: An Environment to Learn Power BI Service for Free
- On the Blue Granite blog, Elayne Jones blogs about Migrating Azure Analysis Services Models to PBI Premium
- Chris Webb (@cwebb_bi) writes Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 4: Query Sessions
- Reid Havens (@HavensBI) discusses Deploying Reports with PBI-Tools with Mathias Thierbach
- On the Marquee Insights blog, Treb Gatte (@tgatte) highlights that Power BI Goals available now with a Pro License and explains how to Add multiple Power BI Goal owners
- Gilbert Quevauvilliers (@GilbertQue) explains How to use the Power BI Embedded Playground
- On the Tessellation Tech blog, Gavin Pedersen explains How to Create a Power BI App
- On the Learning Science YouTube channel, Learning Science describes How to access Power BI Report and Dashboard on Mobile Devices
- Mathias Halkjær Petersen (@HalkjaerM) talks about Complex access control with Row-Level Security
- The Power BI team (@MSPowerBI) explains how to Learn about new centralized data loss prevention policies
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Jeroen ter Heerdt (@jeroenterheerdt) shares the Power BI Report Server January 2022 Feature Summary
- Also on the Power BI blog, Mrigankka Fotedar explains how to Optimize your Processes and Gain Deep Insights with Process Mining
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.