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
- 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
- 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
- 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
- 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
- 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
- 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