Power BI Weekly Issue 114: 15th June 2021
A number of updates this week: you can now Analyze your personal activity in Microsoft Teams with Power BI showing information about your meetings amongst other things (perfect proof that you're probably spending too much time in meetings!) It's now also possible to Embed Power BI in Salesforce, with the team providing some nice Developer samples to help us on our way. Talking about developer samples - there are some New developer samples for update data sources and encrypt credentials in .NET Core, Java and Python. I've previously shown how to do this for an on-prem data source using PowerShell, if you're more comfortable in PowerShell. Finally, it's been highlighted that the On-premises data gateway June 2021 update is now available.
Elsewhere this week, Chris Webb has discussed What The New Visio Web App And Licensing Announcement Means For Power BI (it's good news), Daniil Maslyuk has written a succinct comparison of Power Query in dataflows vs. datasets, and Matt Allington has discussed 5 Productivity Benefits of Tabular Editor 3.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) describes how to Speed Up Power Query In Power BI Desktop By Increasing Or Decreasing The Number Of Evaluation Containers
- Daniil Maslyuk (@DMaslyuk) discusses Power Query in dataflows vs. datasets
- On the Power BI community blog, Eason Fang describes How to extract values of date/currency amount from text strings in Power query
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) talks about Low-Code Data Quality Automation using Power Query - with Gil Raviv, and shares numerous other videos: Extract Parts of a Text Value in Power BI using a Delimiter Power Query Transformation, Split Column by Delimiter in Power BI and Power Query and Create a Table in Power BI using Enter Data and How to Edit it
- Also on the RADACAD YouTube channel, Leila Etaati (@leila_etaati) explains how to Add Column By example in Power Query and shares Power BI live stream data with Power Automate (Part Two)
- Laura Graham-Brown (@Laura_GB) talks about Power Query – Get Previous Row Data
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes Solved! Query folding for native SQL in Power BI
- Bas Dohmen (@HowToPowerBI) describes how to Dynamically Remove All Empty Columns with some M MAGIC in Power BI
- Chandeep Chhabra (@chandeep2786) describes how to Unpivot Cross Tabulated Data with Multiple Headers and Columns
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Matt Allington (@ExceleratorBI) writes about 5 Productivity Benefits of Tabular Editor 3
- Adam Saxton and Patrick Leblanc (@GuyInACube) presents Tabular Editor 3 & Power BI Q&A – LIVE w/ Daniel Otykier & Marco Russo
- Adam Saxton (@GuyInACube) walks through Tracing your DAX queries in Power BI
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) shares: DATEVALUE, TIMEVALUE – DAX Guide, NOW, TODAY, UTCNOW, UTCTODAY – DAX Guide and describes All the secrets of SUMMARIZE
- Also on the SQLBI blog, Marco Russo (@marcorus) explains the wait time when you open a Power BI file – Unplugged #23
- On the Enterprise DNA blog, Nick Mone writes about the Storage Engine In Power BI – VertiPaq Operators & Queries and covers GroupBy In Power BI: An Implied Function In VertiPaq
- Rick de Groot (@Rickmaurinus) covers Understanding Evaluation Context in DAX
- On the Towards Data Science blog, Salvatore Cagliari blogs about Refinement of Semi-Additive Measures in DAX
- Chandeep Chhabra (@chandeep2786) writes about Related and RelatedTable in DAX
- Ruth Pozuelo Martinez (@CurbalEN) talks about DAX Fridays #211: Using inactive relationships in slicers | USERELATIONSHIP
- Hima Bindu Marri (@sivahimabindu) talks about LookupValue in Powe BI
- Brian Julius describes How To Fix Matrix Totals In Power BI
- Sam McKay (@_EnterpriseDNA) describes How To Cumulatively Compare A Best Month Results To The Current Month Using DAX
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains how to Get a field value from a related table in Power BI DAX RELATED Function Explained
- On the Power BI community blog, Ignacio Barrau (@ignacho_07) writes about [DAX] Visualize last N months picking only one from filter context
- On the Prologika blog, Teo Lachev (@tlachev) writes about Power BI Aggregations: Limitations and Workarounds
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Amit Shuster (@ShusterAmit) explains how to Embed Power BI in Salesforce
- Chris Webb (@cwebb_bi) writes about What The New Visio Web App And Licensing Announcement Means For Power BI
- On the Enterprise DNA blog, Mudassir Ali talks about Custom Visual Reports In Power BI and writes about Visual Reports Without Advanced DAX Skills In Power BI
- Adam Saxton (@GuyInACube) talks about the Do’s and Don’t with cascading slicers in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Conditional format a line chart in Power BI
- Reid Havens (@HavensBI) describes how to Conditionally Show/Hide Matrix Columns Using Calculation Groups
- The Power BI team (@MSPowerBI) talks about the Modern visual tooltips in Microsoft Power BI
- On the Burningsuit blog, Alison Box blogs about Charticulator In Power BI 2. and Charticulator In Power BI 3.
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, Amit Shuster (@ShusterAmit) writes about the New developer samples for update data sources and encrypt credentials
- Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) writes that the On-premises data gateway June 2021 update is now available
- The Power BI team (@MSPowerBI) talks about the New enhancements in Power BI app for Teams
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes how to Export Power BI Audit log in a few Simple Steps with No Code
- Matthew Roche (@SQLAllFather) reminds us to Never underestimate the voice of the customer
- On the Marquee Insights blog, Treb Gatte (@tgatte) blogs: Power BI Goals Introduction, Part 3
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, Patrick Baumgartner (@patbaum) explains how to Analyze your personal activity in Microsoft Teams with Power BI
- Dhruvin Shah (@DhruvinShah16) talks about the announcement: Analyze your Personal Activity in Microsoft Teams with Power BI
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 194 - Interview with Andrew Brust
- Reid Havens (@HavensBI) explains how to Identify, Build & Represent Your Power BI Skills with Seth Bauer
- Matthew Roche (@SQLAllFather) shares the Free Power BI Intro Training From Microsoft
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.