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
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- 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
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- 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
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- 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
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- 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
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- 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
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.