Power BI Weekly Issue 189: 10th January 2023
Radio silence from the Power BI team again this week, although the Azure team has told us that the Azure Cosmos DB V2 Connector for Power BI in preview (which now supports DirectQuery!) Elsewhere this week, Kurt Buhler has shared a way to Format Power Query in Power BI, Automatically (spoiler - TE3 may be involved!), Daniel Otykier has joined Reid Havens to also talk about Tabular Editor 3 - this time about DAX Window Functions, and John Kerski has spoken about Bringing DataOps to Power BI.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) writes about OData.Feed And The Dynamic Data Sources Error In Power BI
- Imke Feldmann (@TheBIccountant) shares a Payment function (PMT) for Power Query
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) describes How to show a result when there is no data in Power BI
- On the MSSQLTips site, Kenneth A. Omorodion explains how to Normalize Repeated Data in Power BI reports and Charts with Power Query
- On the Power BI community blog, Milan Mejzr covers Combining multiple Excel files with different sheet names
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) describes How to Create a Power BI report using MySQL data
- The Azure Updates Team (@Azure) announces Public preview: Azure Cosmos DB V2 Connector for Power BI
- On the RADACAD blog, Leila Etaati (@leila_etaati) describes Using Cognitive service for Translation in Power BI
- Lars Schreiber (@SchreiberLars) shares Sind Meine Power BI-Daten Aktuell? [German]
- ,, Kurt Buhler (@kurtbuhler) describes how to Format Power Query in Power BI, Automatically
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Chandeep Chhabra (@chandeep2786) describes how to Never do Sort by Column Again
- On the Learning Science YouTube channel, Learning Science explains How to convert Power BI table into CSV format
- Reid Havens (@HavensBI) talks about [DAX] Window Functions & Tabular Editor 3 (with Daniel Otykier)
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) blogs about Looking through the Window - Calculating customer lifetime value with new DAX functions
- Brian Julius (@_EnterpriseDNA) discusses DAX Magic With The SELECTEDVALUE Optional Parameter In Power BI
- Sam McKay (@_EnterpriseDNA) describes Reusing Moving Averages - Power BI & DAX Trend Analysis Technique [2023 Update] and walks through Calculating Month On Month Change - Custom Calendars In Power BI [2023 Update]
- On the Power BI community blog, João Marcelino writes about Calendar in Power BI
- Patrick Leblanc (@GuyInACube) discusses Wait! Using a Power BI Date slicer, what are my dates when using between? and describes How to handle Aggregation tables with Averages in Power BI
- Also on the Power BI community blog, Amit Chandak (@amitchandak78) describes Power BI Formatted P&L with Custom Sub Totals and Blank Rows
- Kurt Buhler (@kurtbuhler) describes how to Run Tabular Editor Macros with Keyboard Shortcuts & Toolbar Buttons and Count Measures in Power BI Datasets with Tabular Editor
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Enterprise DNA blog, Sue Bayes (@sue_bayes) writes a number of blogs: How To Create Parameters In Power BI's Report Builder, Power BI Paginated Reports: How To Format List and Paginated Reports In Power BI: How To Publish & Export
- James Andrew (@MatadorSoftware) describes how to Conditionally Formatting Power BI Visualizations- A Deep Dive | Rule Based & DAX
- Bas Dohmen (@HowToPowerBI) describes Ultimate Toggle Button in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes How to Create Pop-Up Menu in Microsoft Power BI Dashboard (Desktop Version)
- Reid Havens (@HavensBI) provides an Introduction to Using URLs for Reports in Power BI
- Also on the Enterprise DNA blog, Pascal Kiefer (@Pascal__Ki) blogs about Power BI Videos: How to Embed in Your Reports
- Gaelim Holland (@_EnterpriseDNA) explains How To Increase Scatterplot Options With Python For Power BI
- On the Power BI community blog, Steve de Peijper (@bi2analytics) covers Part 2 - Building a Custom Power BI Visual from scratch (KPI Card)
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Olivier Travers (@otravers) covers Making Sense of Power BI Programmatic Options: REST APIs, PowerShell, TMSL, TOM, Tabular Editor Scripting
- John Kerski (@JKerski) writes about Bringing DataOps to Power BI
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 Patrick White and Jason Himmelstein (@BIFocalShow) presents Episode 245 - Recap of Power BI in 2022
- On the Power BI community blog, Steve de Peijper (@bi2analytics) writes about Series: Predicting Car Prices using Power BI (part 1)
- Simon Harrison (@SimonharrisonD) shares Our Top 5 Power BI Timesavers 2022
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.