Power BI Weekly Issue 62: 9th June 2020
No news to share from the Power BI team this week, so we'll jump straight into some highlighted community blogs. Ben Gribaudo has continued the Power Query M Primer series with a comprehensive blog all about Custom Types (from a syntactical perspective), Darren Gosbell has described how measure formatting works in DAX Studio for those unsure why certain outputs might not be formatted exactly as expected, and Allison Kennedy has written a detailed blog about DAX Context Transition and why it can be handy to use a measure within another measure. Finally, Marc Lelijveld has written a useful (non-technical) blog about Power BI Governance, highlighting a method through which organizations can quality assure new Power BI functionality to gradually expose new functionality to users within their org, to try to combat negative sentiments coming from bugs in preview features, for example.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- Ben Gribaudo (@bgribaudo) writes Power Query M Primer Part 18: Type System III – Custom Types
- Chris Webb (@cwebb_bi) writes Optimising The Performance Of Power Query Merges In Power BI, Part 2: Does When You Remove Columns Matter and Part 3: Table.Join And SortMerge
- Patrick Leblanc (@GuyInACube) presents BANANAS! Power BI dataflows has come a long way...
- Jon Acampora (@excelcampus) explains How to Merge Tables with Power Query – Similar to Vlookup
- Jeff Lenning (@Exceluniversity) describes how to Import PDF Data into Excel with Power Query
- On the SQL Shack blog, Gauri Mahajan (@GauriMahajan12) explains how to Connect Azure Databricks data to Power BI Desktop
- On the MSSQLTips site, Kenneth A. Omorodion discusses Power BI Paginated Reports with Excel Source
- Rui Romano (@RuiRomano) writes about Power BI + Office 365 Forms
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- Darren Gosbell (@darrengosbell) writes about DAX Studio: How measure formatting works
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) shares Model Performance in DAX Studio by Marco Russo
- On the Power BI community blog, Allison Kennedy describes DAX Context Transition: Why it can be handy to use a Measure inside a Measure
- Chandeep Chhabra (@chandeep2786) shares a DAX Crossword Puzzle
- On LaDataWeb, Ignacio Barrau (@ignacho_07) discusses RELATED vs RELATEDTABLE [Spanish]
- Matthew Peterson (@mattpetersonbi) writes about The Power of CALCULATE in Power BI
- Rick de Groot (@ExcelGorilla) describes How to Display Negative Numbers Between Parenthesis in Power BI and explains How to Calculate Same Day Growth in Power BI
- Also on the Power BI community blog, Harsh Nathani discusses Getting Previous Values in Power BI - Part 1
- On the SQL Shack blog, Aveek Das (@avikoleum) discusses Using a Date Dimension Table in Power BI
- On the Towards Data Science blog, Davis Zhang walks through Building and Optimizing Multiple Linear Regression in PowerBI using DAX
- Also on the Power BI community blog, Sam McKay (@_EnterpriseDNA) describes How to Allocate Budgets or Forecasts to Compare to Daily Information - Power BI Analysis Techniques
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- Purna (Chandoo) Duggirala (@r1c1) explains How to make a variance chart in Power BI Easy & Clean
- On the Towards Data Science blog, Freddie Tasker (@tasker_fred) writes about Interactive Power BI Custom Visuals with R
- On the xViz blog, Bhupinder Singh writes about Efficient Project Management in Power BI with the Latest Gantt Chart Edition v1.1.6
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- Gil Raviv (@gilra) blogs about the COVID-19 dashboard in Power BI: Running Averages
- Patrick Leblanc (@GuyInACube) talks about Azure Synapse Analytics & Power BI for BANANAS SCALE! with Josh Caplan
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) describes how to Drillthrough like a PRO in Power BI
- Parker Stevens (@PowerBIElite) discusses Drillthrough on All Columns and Measures in Power BI
- Also on the Towards Data Science blog, Moez Ali (@moezpycaretorg1) describes Topic Modeling in Power BI using PyCaret
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- Marc Lelijveld (@MarcLelijveld) writes about Power BI Governance – New functionality? Govern the implementation in phases
- Adam Saxton (@GuyInACube) describes that Deployment Pipelines give you more CONTROL (Power BI Premium)
- On the Prologika blog, Teo Lachev (@tlachev) writes about Links to Power BI Mobile Reports or Apps
- On the MSSQLTips site, Fikrat Azizov explains how to Automate Azure Analysis Services Management Tasks using Logic App - Part 2
- Sebastian Zolg (@sebastianzolg) writes about Finding Stuff—Using Azure Search and Graph Connectors to Search Your Data.
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- Adam Saxton and Patrick Leblanc (@GuyInACube) shares the REPLAY Power BI tips from the Pros – LIVE Hangout (June 6, 2020)
- Adam Saxton (@GuyInACube) talks about Power BI Workspace Roadmap, DirectQuery dataflows and more... (Roundup | June 1, 2020)
- The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 122
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 148 - May 2020 News Recap
- Jason Cockington writes about 3 Great New Features in Power BI Desktop
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.