Power BI Weekly
Issue #54 - 14th April 2020
This week custom navigation for Power BI apps has become generally available (GA), and we've been told that Shortcuts are now available in the Power BI Android app. A few blogs from us at endjin this week. I've spoken about a technique you can use to programmatically poll for the status of a Dataflow refresh, which opens up numerous scenarios, including the sequential refresh of a Dataflow and Dataset. Carmel has continued her DAX series, talking now about Aggregators, and James has written about Azure Analysis Services: How to update the expression for a calculated column from .NET.
🛠️ Data Prep
- On the Power BI community blog, Ahmed Oyelowo (@AfricanAnalyst) writes To Transpose or Unpivot? What you need to know about table structuring in Power Query
- Also on the Power BI Community blog, Aleksei Zhukov provides a How-To: Union Paginated Web Data Source
- On the Kohera blog, Ilse Moreau (@ilsemoreau) blogs about Budget allocation: combining different levels of granularity in Power BI
- Erik Svensen (@donsvensen) writes about Power Query – Avoid an extra step by not clicking OK
- On the Excelguru blog, Ken Puls (@kpuls) covers Appending Columns with Different Names
- Ignacio Barrau (@ignacho_07) writes Extraer datos de sitios Web (Scraping) [Spanish]
- Lars Schreiber (@SchreiberLars) writes Schritt für Schritt zu Nettoarbeitstagen mit Power Query [German]
- On the edureka blog, Upasana provides An Introduction to the Power Query Editor
🧩 Data Modeling
- On the DataAP blog, Hariharan Rajendran (@imhariharanr) writes about DAX – Daily vs Weekly vs Monthly Measures
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) shares a number of blogs: Showcasing Workday Number in Power BI Using DAX, Discover Multiple Product Purchases Using DAX in Power BI, First Purchase of Customer Insight Using DAX and New Customer Analysis Using Advanced DAX
- On the endjin blog, Carmel Eve (@carmel_eve) writes about Learning DAX and Power BI – Aggregators
- Also on the endjin blog, James Broome writes about Azure Analysis Services: How to update the expression for a calculated column from .NET
- On the Power BI community blog, Pragati11 describes Handling Duplicate Rankings Using the RANKX DAX Function
- Also on the Power BI community blog, vivran22 covers Time Intelligence: Calendar Table
⚙️ Report Design and Visualizations
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes Power BI Reporting Templates Expanded – Power BI Visualization Concepts and describes How To Create Automated & Dynamic Power BI Reports
- David Eldersveld (@dataveld) explains How To Obtain a Power BI Custom Visual If It No Longer Appears on AppSource
- On the Power BI Tips and Tricks blog, Alice Drummond provides a MapBox 101 for Power BI
- On the xViz blog, Jiwon Jeon explains how to Visualize Microsoft Project Data in Power BI using xViz Gantt Chart
⚙️ Data Exploration
- Marc Lelijveld (@MarcLelijveld) talks about Power BI Governance – Why you should consider to disable Export to Excel
- Paul Turley (@paul_turley) writes about Countries with Improved COVID-19 Recovery Rates
- Matt Allington (@ExceleratorBI) explains how to Build your Own Coronavirus Charts with Power BI
- Gil Raviv (@gilra) highlights the COVID-19 App on AppSource
- Mimoune Djouallah (@mim_djo) writes about Analyzing GIS data using BigQuery and Power BI
🚀 Deployment, Security and Operations
- On the Power BI blog, Lukasz Pawlowski (@lukasztweets) announces that designing custom navigation for Power BI apps is now generally available (GA)
- On the endjin blog, Ed Freeman (@edfreeman_) writes about Power BI Dataflow refresh polling
- Marc Lelijveld (@MarcLelijveld) describes how to Share your Power BI dataset and spice up your table and column names
- On the Prologika blog, Teo Lachev (@tlachev) writes about Power BI Source Control
- Gilbert Quevauvilliers (@GilbertQue) covers Creating a Power BI Report from the Audit Logs stored in Azure Blob Storage
- Imke Feldmann (@TheBIccountant) writes about the Power BI "Store datasets in enhanced metadata format" warning
- On the Power BI Community blog, Chris Barber writes about Dynamic Row Level Security (Rls) and Company Hierarchies
🌐 General
- On the Power BI blog, Michal Foster Heldy describes how to Boost your productivity - Shortcuts are now available in the Power BI Android app
- Adam Saxton (@GuyInACube) covers Power BI tips & updates and a COVID-19 USA report (Roundup | April 6, 2020)
- On the Power BI community blog, Sivakumar Harinath covers Power BI Training Content
- Paul Turley (@paul_turley) writes I Need Your Questions about Power BI and Paginated Reports