Power BI Weekly Issue 23: 3rd September 2019
Three updates for you all this week: Maya Shenhav has introduced the new Power BI mobile apps look (in preview), and Christopher Finlan has described What's new for SQL Server 2019 Reporting Services RC1 and announced that URL parameters for Paginated Reports are now available. Elsewhere, Patrick Leblanc has detailed some data modeling best practices in Part 1 of a (presumably) multi-part series, and Ken Puls has been wondering Do Data Types Matter in Power Query?
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- On the Power BI community blog, Mariusz writes about Relative Date Dimension
- Brett Powell (@BrettPowell76) writes about a Time Dimension Table via Power Query
- On the Excelguru blog, Ken Puls (@kpuls) asks Do Data Types Matter in Power Query?
- Gilbert Quevauvilliers (@GilbertQue) describes Creating a Time Dimension using the Power Query Editor in Power BI Desktop
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- Patrick Leblanc (@patrickdba) writes about Power BI Premium Query Profiling with DAX Studio and SQL Profiler and describes Data modeling best practices – Part 1 – in Power BI and Analysis Services
- Gerhard Brueckl (@gbrueckl) covers Data Virtualization in Microsoft Power BI – Part 2
- Chandeep Chhabra (@chandeep2786) writes about COUNTIF in Power BI
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- On the RADACAD blog, Leila Etaati (@leila_etaati) writes about Some of Key Influencers Visual Features
- Carl de Souza (@carldesouza) describes Running an R Visualization from the Marketplace in Power BI, blogs about Installing R for Power BI using CRAN Repository and discusses Installing R Studio for Power BI
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) writes about the New Layout – One
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about From and To Date Slicers in Power BI: Filtering Based on Two Fields
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- On the Power BI blog, Maya Shenhav introduces the Power BI mobile apps new look (preview)
- Also on the Power BI blog, Christopher Finlan (@cmfinlan) writes that URL parameters for Paginated Reports are now available
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about a Scheduled Snapshot of the Power BI Data and Report
- On the Power BI community blog, Amit_PowerBIPro talks about How to view Usage metrics in Power BI workspace and covers the New Workspace Experience Power BI
- Adam Saxton (@guyinacube) talks about What the heck are BUILD PERMISSIONS in Power BI?!?
- Nicky van Vroenhoven (@NickyvV) writes The New Power BI Workspace Viewer Role Explained
- Carl de Souza (@carldesouza) covers Setting up Data Driven Alerts in Power BI and describes how to Post to Microsoft Teams based on Power BI Data-Driven Alert Using Microsoft Flow
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Christopher Finlan (@cmfinlan) highlights What’s new for SQL Server 2019 Reporting Services RC1
- Adam Saxton (@guyinacube) discusses Killer Power BI Custom Branding and more (August 26, 2019)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 115 August 2019 Power BI Desktop Update & News
- On the Power BI community blog, jfeil tells MBAS speakers to Claim Your MBAS Speaker Badge Today! and writes about how Power BI helps Homeless and Troubled Youth
- Mark Smith (@nz365guy) discusses The Power BI Story with Arun Ulagaratchagan
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.