Power BI Weekly Issue 101: 16th March 2021
This week, the Power BI team has revisited an article they wrote back in December 2019, talking about Power BI as a superset of Azure Analysis Services. Christian Wade highlights all the features that Power BI Premium has inherited from AAS, and the additional features on top of that set which makes Premium a very compelling product. Of course, there's still the cost disparity between AAS and Premium, which can be a blocker for companies wanting to make the migration. However, with PPU we have an additional option which wasn't available back then which provides a much more reasonable migration option. And on that note, Martin Schoombee has written about Pro, PPU, and AAS pricing in the useful blog: Should I move to Power BI Premium Per User?.
Elsewhere this week, Amit Shuster has joined Adam Saxton on GuyInACube to talk about the new updates for the Power BI Embedded Playground with Amit Shuster (2021) mentioned in last week's editorial, Anthony Escobedo has described various ways of Using Power Apps, Power BI and Power Automate Together to get the most out of the Power Platform, and Reid Havens has described how to layer visuals to create the effect of having Adjustable Bands and KPIs on a Line Chart.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Kasper de Jonge (@kjonge) talks about Everything Power BI dataflows with Matthew Roche
- Gilbert Quevauvilliers (@GilbertQue) covers Power Query – Remove all characters before delimiter & after delimiter
- On the Access Analytic blog, Wyn Hopkins (@wynhopkins) explains how to Consolidate Excel worksheets with Power Query
- Jeff Lenning (@Exceluniversity) describes how to Split Column Headers from Values
- Marcus Wegener (@PowerBIler) talks about the new tool: Export Power BI Desktop Data Preparation to Dataflow
- Reid Havens (@HavensBI) writes about Intelligent Error Handing within Power Query (with Reza Rad)
- Bas Dohmen (@HowToPowerBI) explains how to Combine From Folder in Power BI | What to do when new columns don't show
- Parker Stevens (@PowerBIElite) explains how to Validate Email Addresses in Power BI
- Chris Webb (@cwebb_bi) walks through Comparing The Performance Of Importing Data Into Power BI From ADLSgen2 Direct And Via Azure Synapse Analytics Serverless, Part 3: Parquet Files
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) highlights the DAX Guide Update
- On the SQLBI blog, Marco Russo & Alberto Ferrari write about USERELATIONSHIP in calculated columns
- Patrick Leblanc (@GuyInACube) describes how to TAME the the beast that is DAX in Power BI (aka how to learn DAX)
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 183 - Whither Power Pivot
- Sam Fischer writes about Displaying ordinal numbers in your Power BI Smart Narratives
- On the Access Analytic blog, Wyn Hopkins (@wynhopkins) writes about some Power BI Hidden Gems
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) writes about Market Basket Analysis
- On the Power BI community blog, Antriksh Sharma explains How to build queries using DAX Studio's user interface
- John White (@diverdown1964) writes that It's time to stop using Power Pivot
- Bas Dohmen (@HowToPowerBI) talks about DAX Shortcuts in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about What IF Analysis in Microsoft POWER BI | Narration | Explain the Increase | DAX - Calculate DateAdd and explains how to Calculate the Time between Two Dates in Microsoft Power BI (Days, Months, Years) | DATEDIFF DAX
- Ruth Pozuelo Martinez (@CurbalEN) writes DAX Fridays #200: Calculate the MAX of a measure
- Hima Bindu Marri (@sivahimabindu) explains how to Convert Integer value to Date format in Power BI
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Tabular Editor empowering the Power BI - by Daniel Otykier
- Sam McKay (@_EnterpriseDNA) discusses Pros & Cons of Quick Measure In Power BI - A New And Better Way To Boost Productivity
- Greg Philps writes about Data Modelling - Power BI Best Practices
- Jarret Moore talks about the Anomaly Detection Feature In Power BI
- Mudassir Syed Rashid Ali provides A New Look At CALCULATE - Power BI
- The Power BI team (@MSPowerBI) describes the Updates to the Model view in Microsoft Power BI
- Marc Lelijveld (@MarcLelijveld) blogs about Webinar Data Modeling 101: Increasing the impact of Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Reid Havens (@HavensBI) covers Adding Adjustable Bands and KPIs to a Line Chart
- Chandeep Chhabra (@chandeep2786) describes how to Automatically Set Equal Column Width in a Matrix Visual for Power BI
- On the Power BI community blog, Pragati Jain writes about My Take on Waterfall Chart Visual in Power BI
- Bas Dohmen (@HowToPowerBI) discusses Status Bar in Power BI | Build your own Linear Gauge
- On the Data Bear blog, Edward Van Der Merwe writes about Power BI Small Multiples
- Dhruvin Shah (@DhruvinShah16) explains how to Create a Comparison Report in Power BI and describes How to Display SharePoint Images to Power BI
- Also on the Power BI community blog, Steve de Peijper tells us to Checkout these awesome keyboard shortcuts
- On the Business Intelligist blog, Business Intelligist (@bizintelligist) describes How to Fix Power BI Map Geocoding Issues
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Brett Powell (@BrettPowell76) shares Common Power BI Admin Scripts Part II
- Ruth Pozuelo Martinez (@CurbalEN) describes How to refresh web sources in Power BI service
- Martin Schoombee (@MartinSchoombee) writes Should I move to Power BI Premium Per User?
- Teo Lachev (@tlachev) writes about Solving RLS Gotchas
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Christian Wade (@_christianWade) writes about Power BI as a superset of Azure Analysis Services
- Gil Raviv (@gilra) discusses the Power BI Twitter Dashboard
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Power BI tips from the Pros – LIVE (Mar 13, 2021) (Member Chat 2nd Half)
- Adam Saxton (@GuyInACube) talks about the INSANE AMAZING updates for the Power BI Embedded Playground with Amit Shuster (2021)
- Amit Shuster (@ShusterAmit) talks about Embedding Microsoft Power BI in a React application
- On the Power BI blog, Kelly Kaye (@MS_KellyKaye) writes Join us! Power BI Instructor Led Training! Data Modeling & Shaping on 24 & 25 March 1:00 PM-5:00PM PDT
- On the Power BI Tips and Tricks blog, Anthony Escobedo (@anton3sco) describes Using Power Apps, Power BI and Power Automate Together
- John White and Jason Himmelstein (@bifocalshow) present Episode 182 - Premium per User with Chris Finlan
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.