Power BI Weekly Issue 206: 9th May 2023
This week we've had a pretty clear call-to-action to Register for Microsoft Build to hear what's next with Power BI, Synapse and Data Factory, with various senior MSFT folks spreading the message on Twitter. On that link, you'll also find a short BUILD promo video from Adam and Patrick - seems like there's something worth tuning in for! The only feature announcement this week is that you can Now use item links to configure Power BI Tabs in Microsoft Teams - the integration that just keeps on improving.
Elsewhere this week, Chris Wagner has written a great overview blog about Power BI usage scenarios: Lakehouse to Power BI, and Sam Fischer has described the importance and usefulness of Implementing error checks in Power Query.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Sam Fischer (@ApexInsightsPBI) describes Implementing error checks in Power Query
- On the Power BI community blog, Melissa de Korte describes how to Set up easy debugging and improve M code adoption with record-expressions
- Also on the Power BI community blog, Milan Mejzr writes about Dynamic text search in Power Query
- On the Kohera blog, Kohera (@Kohera_be) write about How do you link an SCD Type 2 table in Power Query?
- Kim Leblanc covers Données groupées par semaine débutant à une journée choisie [French]
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) explains How to Add Power BI to Excel: A Step-By-Step Guide
- Chandeep Chhabra (@chandeep2786) presents a live stream: Solving Tricky Data Cleaning Problems using M in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Adam Saxton (@GuyInACube) discusses The Heart of Power BI
- Chris Webb (@cwebb_bi) shares Power BI DirectQuery Best Practices Video
- On the SQLBI blog, Marco Russo (@marcorus) describes Optimizing text search in DAX
- Chris Wagner writes about Power BI usage scenarios: Lakehouse to Power BI
- Rick de Groot (@Rickmaurinus) shares their latest blog: When to use Measures vs Calculated Columns in Power BI
- Dhruvin Shah (@DhruvinShah16) talks about Power BI: Dynamic Format String for Measures
- Philipp Lenz (@lenz_philipp) writes about Suggested Measure Feature are not available?
- Hima Bindu Marri (@sivahimabindu) describes Day of the week in Date Table in Power BI
- Sam McKay (@_EnterpriseDNA) talks about Using ALLEXCEPT To Stop Cumulative Total From Resetting [2023 Update], explains how to Find Your Top 3 Salespeople Per Region Automatically In Power BI Using DAX [2023 Update], discusses Calculating Averages Per Transaction Using DAX In Power BI [2023 Update] and talks about Calculating Average Monthly Purchases In Power BI Using DAX [2023 Update]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Erik Svensen (@donsvensen) describes Adding a vertical bar to your slicer
- Fowmy Abdulmuttalib (@ExcelFort) explains How to Transform a Line Chart into an Insightful KPI Visual in Power BI
- On the Learning Science YouTube channel, Learning Science describes Dynamic calculated title for visuals in Power BI
- Jarrett Moore (@BuckeyeJarrett) discusses Grouping Bookmarks by Report Page In Power BI [2023 Update]
- Reid Havens (@HavensBI) discusses The World's Best Theme Generator for Power BI with Mike Carlo
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, Lukasz Pawlowski (@lukasztweets) shares Announcing: Now you can use item links to configure Power BI Tabs in Microsoft Teams
- Marc Lelijveld (@MarcLelijveld) covers Controlling Workspace Creation in Power BI: How to Strike the Right Balance?
- Patrick Leblanc (@GuyInACube) covers RLS in the source? How does this work with DirectQuery and Import in Power BI?
- On the phData, Gavin Pedersen (@gavin_PD) describes How To Use The Power BI Premium Capacity Metrics App
- Darren Gosbell (@darrengosbell) walks through Logging Parameters for a Paginated Report
- Ignacio Barrau (@ignacho_07) covers [GIT] Versionando PowerBi trabajando en equipo - previa para CI/CD [Spanish]
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, Tyler Mays-Childers (@MSPowerBI) announces Microsoft Digital Event | May 24-25
- Matthew Roche (@SQLAllFather) shares It’s going to be big – join the Power BI team at Build
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 255 - Interview with Rosie Levasseur
- CloudStakes Technology describes how to Embed Power BI Content in a Model-Driven App System Dashboard
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.