Power BI Weekly Issue 41: 14th January 2020
Radio-silence from the Power BI team this week, so let's dive straight into the highlighted blogs. Miguel Escobar has compared DAX and Power Query solutions in their blog Static Segmentation in Power BI / DAX / Power Query, Ben Gribaudo has written about Control Structure in their Power Query M Primer series, and Teo Lachev has shared some interesting findings about the Power BI Pro Storage Quota.
This week I also want to mention a new community site created by Ignacio Barrau, which is intended to be a place where anyone can share their Power Platform / Azure Data Platform content (for free). The site's content is currently in Spanish, but with the power of auto-translation within browsers nowadays, this shouldn't stop you from consuming the content! This site is called LaDataWeb, and you'll find a blog from this site further down the newsletter. You'll see blogs written in a non-English language tagged with [<language>].
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the RADACAD blog, Reza Rad (@Rad_Reza) explains how to Get the Image URL in Power BI Using Power Query Get Table from Example, covers Power BI Get Data from Multiple Files in a Folder on OneDrive for Business, No Gateway Needed and describes how to Reference from Another Query in Dataflow – No Premium Needed – Power Platform Dataflows
- Ben Gribaudo (@bgribaudo) writes Power Query M Primer (Part 14): Control Structure
- Matt Allington (@ExceleratorBI) discusses Extracting Data from Complex Web Pages with Power BI
- Parv Chana (@parvchana) writes about Self-serve data prep at lightening fast speed with Power BI dataflows and Azure Data Lake
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) talks about DAX vs Power Query: Static Segmentation in Power BI / DAX / Power Query
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the RADACAD blog, Reza Rad (@Rad_Reza) highlights the New Video Course: DAX and Calculations in Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) posts a few blogs: Advanced DAX For Power BI: Implementing Ranking Logic Across Unique Insights, A Power BI Training On Budgeting Scenarios Using DAX, Advanced Analytics in Power BI: Layering Multiple 'What If' Analysis, Scenario Analysis Techniques Using Multiple 'What If' Parameters and Compare Multiple Metrics Cumulatively In Power BI Using Advanced DAX
- Patrick Leblanc (@GuyInACube) presents Want to use a URL for your text column in Power BI Desktop? Check THIS out! and provides 3 REASONS to use a single dataset for your Power BI reports
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the SQLBI blog, Marco Russo (@marcorus) writes about Why reports obtained with Analyze in Excel can be slower
- On the Visual BI blog, Bhupinder Singh blogs about Gannt Chart Configuration for Power BI – A Step by Step Guide and walks through Alerting Techniques in Gannt Chart for Microsoft Power BI
- Also on the Visual BI blog, Vipin Suresh covers Data Label Customization Funnel/Pyramid Chart for Microsoft Power BI
- On the Blue Granite blog, Jason Cantrell provides a Deep Dive into Linear Regression in Power BI: Key Influencers
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes Diseñando fondos de reportes [Spanish]
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares some Power BI Mobile Reporting Tips and Techniques
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- Brett Powell (@BrettPowell76) explains how to Retrieve Power BI Pro Licensed Users
- On the Prologika blog, Teo Lachev (@tlachev) writes about the Power BI Pro Storage Quota
- Gil Raviv (@gilra) writes about Power BI Pixel – A new way to track usage on Power BI
- Paul Turley (@paul_turley) blogs about Getting Started with the New Power BI Activity Log API
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- Matthew Roche (@SQLAllFather) blogs about Building a data culture
- On the RADACAD blog, Reza Rad (@Rad_Reza) shares a Microsoft Regional Directors Power BI Report and writes about What Happens to Your Job With the Revolution of Power BI and Self-Service BI
- On the Prima blog, David Johnston highlights 5 Resources to Help a Power BI Developer
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.