Azure Weekly - Power BI Weekly #201 - 4th April 2023
Power BI Weekly Newsletter Issue #201
powered by endjin
Welcome to the 201st edition of Power BI Weekly! Just a single announcement this week - a small (yet mighty) feature has landed, which is the ability to Pin workspaces in the Power BI Service. Finally! Thanks to the Power BI team for listening to the community on this one. Elsewhere this week, Matthew Adams has elaborated on the importance of Asking the right questions to get your data insights projects back on track. In it, Matthew shares a new (free) high-level Power BI Maturity assessment we've devised at endjin to help you understand your organization's maturity based on three fundamental activities: understanding who is involved, how they derive value from your Power BI activities, and how they communicate with each other. Do take a read through that blog if you're interested!
I'll finish off the editorial with a couple of "programmatic" tips this week: Gilbert Quevauvilliers has highlighted the Resolve-PowerBIError
PowerShell cmdlet in the blog Troubleshooting Power BI PowerShell issues to view the error (which, despite being very familiar with the various Power BI SDKs, I'd somehow not come across before). This, unsurprisingly, provides a bit more information about errors that other PowerShell Power BI cmdlets may throw, which, by themselves, tend to be very vague. The other blog I'd like to highlight is written by Nandan Hegde, who has spoken about Overcoming Data Size / Row Limitations of Power BI REST API for Automated Data Extraction from Dataset. If you need to extract more than 15MB / 100,000 values, this is well worth a read.
If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.
Interested in Azure? Sign up to our sibling newsletter Azure Weekly to receive all the week's Azure news.
@edfreeman_ | @endjin
powerbiweekly.info | endjin.com
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Belinda Allen (@MsBelindaAllen) explains how to Add a prefix to a field in Microsoft Power BI via Power Query
- Denis Selimovic (@DenSelimovic) writes about One-step conditional value replacement in a column in Power Query
- Chandeep Chhabra (@chandeep2786) describes how to Remove Random Null Values from Columns
- Olivier Travers (@otravers) writes about Connecting to Power BI Datamart and PowerApps Dataverse's SQL Server from Desktop Tools and External Services
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Optimizing fusion optimization for DAX measures
- On the SQL Server Central blog, Jared Westover (@WestoverJared) describes DAX CASE Statement Functionality with IF, SWITCH and SWITCH True
- Sam McKay (@_EnterpriseDNA) explains How To Detect And Visualize Outliers Using DAX In Power BI [2023 Update]
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes how to Place all explicit measures in one table in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Mara Pereira (@datapears) covers The Importance of User Experience in Reporting and Power BI - A Must-Read Guide
- Marc Lelijveld (@MarcLelijveld) blogs about The Truth About Hiding Pages in Power BI Reports: Why It's Not a Security Feature
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) describes On object interaction (Opt-in) and talks about Star Rating Visual in Microsoft Power BI
- Bas Dohmen (@HowToPowerBI) discusses Slicer design 2.0 in Power BI | Upgraded functionality and UX and explains how to Add power to your titles in Power BI | The one trick you need to know
- Brian Julius (@_EnterpriseDNA) explains How To Create Fully Dynamic Image Slicers In Power BI
- On the Select Distinct blog, Select Distinct (@SelectDistLtd) blogs about Sparklines in Power BI
- On the Learning Science YouTube channel, Learning Science talks about Sankey Chart in Power BI - Custom Visual
- Dhruvin Shah (@DhruvinShah16) talks about the Apply All and Remove All Button in Power BI
- On the MSSQLTips site, Harris Amjad (@mssqltips) explains How to use the Custom Power KPI Visual in Power BI
- Matt Allington (@ExceleratorBI) explains how to Build a Power BI Paginated Report Online
- Laura Graham-Brown (@Laura_GB) describes Power BI – Embed a Paginated Report
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, Yichao Wu (@MSPowerBI) announces Pin workspaces
- Reid Havens (@HavensBI) walks through Introducing TMDL for Power BI (with Mathias Thierbach) and presents Power BI Governance (Why Should I Care) (with Ásgeir Gunnarsson)
- Gilbert Quevauvilliers (@GilbertQue) describes Troubleshooting Power BI PowerShell issues to view the error
- Chris Webb (@cwebb_bi) covers Identifying CPU And Memory-Intensive Power Query Queries During Refresh In The Power BI Service
- Nandan Hegde (@nandan_hegde15) describes Overcoming Data Size / Row Limitations of Power BI REST API for Automated Data Extraction from Dataset
- On the RADACAD blog, Reza Rad (@Rad_Reza) writes about Content Certification in Power BI: One Step Towards a Better Governance
- Patrick Leblanc (@GuyInACube) describes how to Switch a Power BI Report’s dataset without needing Premium
- Antriksh Sharma (@AntrikshShar) explains how to Refresh Individual Power BI Tables or Partitions with PowerShell
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) talks about Last Refreshed in Power BI (Desktop + Service) and delves into Getting Started with Microsoft Power BI Service
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the endjin blog, Matthew Adams (@ythos) writes Ask the right questions to get your data insights projects back on track
- On the BIFocal podcast, John Patrick White and Jason Himmelstein (@BIFocalShow) present Episode 251 - Power BI News Updates
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 219
Useful Links
- Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
- M language reference - Official Power Query M Reference
- DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
- DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
- Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
- Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
- Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
- Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
- Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
- Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more
Tweet | Forward | Preferences | Unsubscribe
Key phrases
Older messages
☁️ Azure Weekly #412 - 2nd April 2023
Sunday, April 2, 2023
Azure Weekly Newsletter Issue #412 powered by endjin Welcome to issue 412 of Azure Weekly! This week saw the Azure Cosmos DB Conf 2023. There's a YouTube Playlist available of all the talks and I
Power BI Weekly #200 - 28th March 2023
Tuesday, March 28, 2023
Power BI Weekly Newsletter Issue #200 powered by endjin Welcome to the 200th edition of Power BI Weekly! Another milestone for the Power BI Weekly newsletter - thanks as ever to all of you for
☁️ Azure Weekly #411 - 26th March 2023
Sunday, March 26, 2023
Azure Weekly Newsletter Issue #411 powered by endjin Welcome to issue 411 of Azure Weekly! As you can probably guess it's an "AI all the things" week, with lots of announcements about
Power BI Weekly #198 - 14th March 2023
Tuesday, March 14, 2023
Power BI Weekly Newsletter Issue #198 powered by endjin Welcome to the 198th edition of Power BI Weekly! A few more announcements this week. Possibly the most exciting of the announcements is the (opt-
☁️ Azure Weekly #409 - 12th March 2023
Sunday, March 12, 2023
Azure Weekly Newsletter Issue #409 powered by endjin Welcome to issue 409 of the Azure Weekly Newsletter. The big announcement this week is that ChatGPT is now available in Azure OpenAI Service. There
You Might Also Like
📧 What's inside MMA and how it can help you
Friday, April 26, 2024
What's Inside Modular Monolith Architecture? Hey there! 👋 I wish you an excellent end to the week. What better way to spend the weekend than diving headfirst into a 12+ hour course? Well, maybe
Data Science Weekly - Issue 544
Friday, April 26, 2024
Curated news, articles and jobs related to Data Science, AI, & Machine Learning ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Develop highly relevant search applications using AI
Friday, April 26, 2024
New Elasticsearch and AI training ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ ㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤㅤ elastic | Search. Observe. Protect A world of AI possibilities door-test 2.png Explore
Stripe makes more changes
Thursday, April 25, 2024
TikTok is in trouble, and net neutrality is back View this email online in your browser By Christine Hall Thursday, April 25, 2024 Welcome back to TechCrunch PM, your home for all things startups,
💎 Issue 414 - From a Lorry Driver to Ruby on Rails Developer at 38
Thursday, April 25, 2024
This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 414 Release Date Apr 25, 2024 Your weekly report of the most popular Ruby news, articles and
💻 Issue 414 - JavaScript Features That Most Developers Don’t Know
Thursday, April 25, 2024
This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 414 Release Date Apr 25, 2024 Your weekly report of the most popular Node.js news, articles and
💻 Issue 407 - The Performance Impact of C++'s `final` Keyword
Thursday, April 25, 2024
This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 407 Release Date Apr 25, 2024 Your weekly report of the most popular .NET news, articles and projects
💻 Issue 414 - Everyone Has JavaScript, Right?
Thursday, April 25, 2024
This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 414 Release Date Apr 25, 2024 Your weekly report of the most popular JavaScript news, articles
📱 Issue 408 - All web browsers on iOS are just Safari with different design
Thursday, April 25, 2024
This week's Awesome iOS Weekly Read this email on the Web The Awesome iOS Weekly Issue » 408 Release Date Apr 25, 2024 Your weekly report of the most popular iOS news, articles and projects Popular
💧 Don't Bother Liquid Cooling Your AMD CPU — Why You Should Keep Using Live Photos on iPhone
Thursday, April 25, 2024
Also: We review the Unistellar Odyssey iPhone Telescope, and More! How-To Geek Logo April 25, 2024 Did You Know Charles Darwin and Abraham Lincoln were both born on the same day: February 12, 1809. 💻