Power BI Weekly Issue 24: 10th September 2019
There's been very little from the Power BI team in the last week; in fact, nothing at all at the time of curating this newsletter! Here is this week's highlighted content: Soheil Bakhshi has very helpfully demystified all the different ways of authoring reports within the Power BI ecosystem, Michal Dvorak has written an interesting article on Transitive Closure in Power Query, and John and Jason from the BiFocal show share an Interview with Marco Russo in the latest episode of their podcast.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- Carl de Souza (@carldesouza) discusses Using Python as a Data Source in Power BI and blogs about Using Python to Filter Data in Power Query
- On the Power BI community blog, Michal Dvorak (@nolockcz) writes about Transitive Closure in Power Query
- Gil Raviv (@gilra) writes about A new facebook connector error
- Matt Allington (@ExceleratorBI) describes Renaming all the Columns in a Table at Once using Power Query (M Language)
- Chris Webb (@cwebb_bi) discusses The AutoSetDefaultInitialCatalog Analysis Services Server Property
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 116 - Interview with Marco Russo
- Abu Hasan discusses Text.Split using DAX
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Using SAMEPERIODLASTYEAR To Compare The Difference Between This Year & Last Year and talks about Using Variables in Power BI – A Detailed Example
- Patrick Leblanc (@GuyInACube) describes Where to create your columns in Power BI | Data Modeling Best Practices
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- Carl de Souza (@carldesouza) writes a number of blogs: Running an R Visualization in Power BI Desktop, Install R Packages for Power BI R Visualizations, Installing and Setting Up Python for Power BI and Using the Python Visualization for Power BI
- David Eldersveld (@dataveld) shares some Videos for the Power BI Periodic Table of the Elements and describes the 3D Effect with Orthographic Projection in Power BI
- Soheil Bakhshi (@biinsightnz) writes Power BI Ecosystem Report Authoring Tools Demystified
- Mimoune Djouallah (@mim_djo) describes How to Build a near real time Dashboard using Datastudio and BigQuery
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- Marc Lelijveld (@MarcLelijveld) posts Storytelling with Power BI 6/7: Progressive disclosure
- On the SQLBI blog, Marco Russo (@marcorus) delves into Creating a slicer that filters multiple columns in Power BI
- Gilbert Quevauvilliers (@GilbertQue) describes Hiding the Filter Pane on opening a report or in Full screen mode in Power BI
- Adam Saxton (@GuyInACube) explains how to Build a Slicer Panel in Power BI and take it to the next level
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- On the MSSQLTips site, Scott Murray writes about Power BI Row Level Security
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) provides a Power BI Refresh - Overview
- David Eldersveld (@dataveld) answers What's CefSharp in Power BI Desktop?
- Patrick Leblanc (@GuyInACube) explains how to Take Power BI data alerts to the next level with Microsoft Flow
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- Adam Saxton (@GuyInACube) presents Power BI Paginated URL Parameters are here (Roundup | September 2, 2019)
- On the Powered Solutions blog, Miguel Escobar (@EscobarMiguel90) writes New Microsoft Data Platform MVP & New Website Design for PowerQuery.Training
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.