Power BI Weekly
Issue #141 - 25th January 2022
A very exciting set of announcements around Deployment Pipelines this week, including a handy new Azure DevOps extension, Dataflows and Linked entities support going GA, and my personal favourite: multiple pipelines can now be integrated with one another, in the sense that you can have one pipeline managing your shared (centralized) datasets and others managing corresponding reports, with the dev, test and prod stages of each pipeline staying aligned. This means that dev reports are bound to dev datasets, test reports to test datasets, and prod reports to prod datasets. Sounds so simple, but a huge improvement - thanks to the Power BI team for making this happen!
Elsewhere this week, Antriksh Sharma has described Working With Expanded Tables In Power BI, James Andrew has described how to change Power BI Custom Icons depending on the time using DAX and UNICHAR, and Marc Lelijveld has started a governance series about Power BI Workspace setup.
🛠️ Data Prep
- Ben Gribaudo (@bgribaudo) writes about Power Query M Primer (Part 23): Query Folding I
- Adam Saxton (@GuyInACube) explains How we optimize Power Query and Power BI Dataflows
- Brian Julius (@_EnterpriseDNA) explains How To Obtain Previous Week Values In Power BI
- On the Towards Data Science blog, Peter Hui discusses Power BI—Table, Lists and Records
- Parker Stevens (@PowerBIElite) describes Scraping Amazon Product Data using Python and Power BI
- Ruth Pozuelo Martinez (@CurbalEN) explains You are getting files from folders the wrong way in Power BI: Here is how to fix it
🧩 Data Modeling
- On the endjin blog, Elisenda Gascon (@elisendagascon) discusses Evaluation Contexts in DAX - Relationships and describes Evaluation Contexts in DAX - Context Transition
- Alberto Ferrari (@FerrariAlberto) writes about Using ALLSELECTED in composite models, on the SQLBI blog, talks about SQRT, POWER – DAX Guide and covers GEOMEAN, GEOMEANX – DAX Guide
- Urish Arora (@urisharora) shares a few blogs: Main differences between SQL and DAX, Building Queries Manually In DAX Studio and In Power BI exclude slicer selection from the result with DAX
- Reid Havens (@HavensBI) describes Auto-Scaling for DAX - KPI Strings?
- James Andrew discusses Changing Power BI Custom Icons Depending on the Time (DAX | UNICHAR)
- Antriksh Sharma (@_EnterpriseDNA) talks about Working With Expanded Tables In Power BI
- Mimoune Djouallah (@mim_djo) talks about Power BI Hybrid Table, you can have your cake and eat it too
- Bas Dohmen (@HowToPowerBI) describes Hybrid Tables in Power BI
- Belinda Allen (@MsBelindaAllen) blogs about Microsoft Dynamics Business Central as a Data Type in Excel via Power BI
📊 Report Authoring and Interactivity
- Pat Mahoney (@mahoneypa) describes Power BI - Scrolling with the Deneb Visual
- Brian Julius (@_EnterpriseDNA) describes How To Dynamically Control Font Properties Via DAX
- Sam McKay (@_EnterpriseDNA) covers Transformation High-Level Analytics with Power BI
- Hima Bindu Marri (@sivahimabindu) talks about Small multiples in Power BI
- On the Learning Science YouTube channel, Learning Science describes Small Multiples in Power BI
- On the SQL Server Central blog, Scott Murray discusses Power BI Zoom and Focus
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) covers Report Page Tooltips in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes How to pick stunning colors for your Power BI reports
🚀 Deployment, Security and Operations
- On the Power BI blog, Nimrod Shalit writes about Deployment pipelines- Azure DevOps extension, multiple pipelines working together, Dataflows GA
- Chris Webb (@cwebb_bi) describes how to Monitor Power BI Queries And Refreshes With DirectQuery On Log Analytics, Part 3: Queries
- On the Power BI community blog, Ye Tao discusses Is there a limit to the number of embed tokens?
- Marc Lelijveld (@MarcLelijveld) discusses Power BI Workspace setup – Part 1
- Adam Saxton (@GuyInACube) talks about Power BI Premium Gen2 updates (January 2022)
🌐 General
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Jan 22, 2022) (Member Chat 2nd Half)
- James Andrew explains how to Get Practice Power BI Datasets with these 5 Great Resources