📈 Power BI Weekly #195 - 21st February 2023
Power BI Weekly Newsletter Issue #195
powered by endjin
Plenty of announcements this week. We've been given the Power BI February 2023 Feature Summary. Improvements this month include the Enhanced row-level security editor, whereby you can now quickly and easily define row-level security roles and filters without having to write any DAX. There's the release of two New statistical DAX functions: LINEST and LINESTX, the addition of New accessible report themes, and it is also now possible to Set conditional formatting rules based on string fields.
Elsewhere this week, the Power BI team have announced the Availability Expansion of the SSRS Migration Tool to Power BI. There's the release of the Quick Create SDK, a new form of Power BI embedded analytics that enables you to embed an interactive data exploration and report creation experience in your applications. Finally, we've been told that the Export to Excel Improvements for Matrix Visuals feature is now generally available.
Ed is currently on holiday; this issue was curated by Jessica Hill.
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
- On the Enterprise DNA blog, Melissa de Korte Enterprise Dna Expert shares Power BI Replace Text Tutorial: Conditional Full & Partial Replacement
- Antriksh Sharma (@AntrikshShar) shares 445, 454, or 544 Week table in Power BI and Excel
- Lars Schreiber (@SchreiberLars) covers So filterst Du richtig in Power Query [German]
- On the Learning Science YouTube channel, Learning Science describes How ChatGPT helps to write M Code in a PowerQuery | AI assistance for Power Query M code in Power BI
- Ben Gribaudo (@bgribaudo) covers Value.ReplaceType & Table Column Renames (Bug Warning)
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Reid Havens (@HavensBI) talks about New Relationship Pane Walkthrough for Power BI Desktop and discusses Relationship Editor Pane (Model View) in Power BI Desktop
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) delves into Understanding blank row and limited relationships
- On the Towards Data Science blog, Salvatore Cagliari (@TDataScience) explains How to use FILTER in DAX the correct way
- Sam McKay (@_EnterpriseDNA) explains How To Use The GROUPBY Function In Power BI and explains how to Detect Abnormal Patterns In Behaviour Using DAX In Power BI [2023 Update]
- Brian Julius (@_EnterpriseDNA) explains How To Easily Create And Organize Multiple Measures At Once In Power BI
- Darren Gosbell (@darrengosbell) writes about Automatically generating measure descriptions for Power BI and Analysis Services with ChatGPT and Tabular Editor
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Ikechukwu Edeagu (@MSPowerBI) announces Export to Excel Improvements for Matrix Visuals (GA)
- On the Enterprise DNA blog, Brian Julius (@_EnterpriseDNA) walks through Adding A Power BI SVG Visual On Your Report and discusses Using R In Power BI: Creating Complex Visuals
- On the MSSQLTips site, Harris Amjad (@mssqltips) explains How to create a Sankey Chart in Power BI Desktop
- Glen Leck (@BI_ographic) discusses Mind the Gap
- Gaelim Holland (@_EnterpriseDNA) explains How To Bring In Summary Statistics and Correlation Tables In Power BI Using Python
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, Harleen Kaur (@MSPowerBI) announces Empower your application users to quickly explore their data with the new Power BI Embedding capabilities
- Amanda Rivera and Ted Pattison (@MSPowerBI) present Power BI Dev Camp Session 29 - Developing with the Power BI Quick Create SDK
- Also on the Power BI blog, Cookie McCray (@MSPowerBI) announces Availability Expansion of the SSRS Migration Tool to Power BI
- Patrick Leblanc (@GuyInACube) covers Publish/Migrate your RDL files from Power BI Report Server to the service
- Chris Webb (@cwebb_bi) discusses Power BI Migration Tools: What They Can And Can’t Do
- Rui Romano (@RuiRomano) presents Power BI Dev Camp Session 28 - How To Monitor Your On-prem Power BI Gateways
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) blogs about Power BI App: Changing The Paradigm In Data Management & Transformation
- Adam Saxton (@GuyInACube) discusses Dataset permissions required for App report in Power BI? What am I missing?
- On the Prologika blog, Teo Lachev (@tlachev) discusses Demystifying Power BI Dataset Scale-out
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) describes Streaming data Azure & Power BI - Stream Analytics
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, Ryan Majidimehr (@MSPowerBI) announces Power BI February 2023 Feature Summary
- Miguel Félix covers Atualização Power BI Fevereiro 2023 [Portuguese]
- Microsoft Power BI (@MSPowerBI) announces Power BI Update - February 2023
- On Acuity Training, Ben Richardson (@AcuityTraining) shares Power BI Tips & Tricks: 15 Experts Give Their Top 3 Tips
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 #406 - 19th February 2023
Sunday, February 19, 2023
Azure Weekly Newsletter Issue #406 powered by endjin Welcome to issue 406 of Azure Weekly! There are a number of analytics based announcements this week. First off, the General Availability of Azure
Power BI Weekly #194 - 14th February 2023
Tuesday, February 14, 2023
Power BI Weekly Newsletter Issue #194 powered by endjin Welcome to the 194th edition of Power BI Weekly! A couple of announcements this week: we've been told about the administrative capability to
Power BI Weekly #191 - 24th January 2023
Tuesday, January 24, 2023
Power BI Weekly Newsletter Issue #191 powered by endjin Welcome to the 191st edition of Power BI Weekly! A flurry of exciting announcements this week. Firstly, we've been told about the Public
☁️ Azure Weekly #402 - 22nd January 2023
Sunday, January 22, 2023
Azure Weekly Newsletter Issue #402 powered by endjin Welcome to issue 402 of Azure Weekly. A relatively quiet week; the first big announcement is the General availability of Azure OpenAI Service
☁️ Azure Weekly #401 - 15th January 2023
Friday, January 20, 2023
Azure Weekly Newsletter Issue #401 powered by endjin Welcome to issue 401 of Azure Weekly - the first of 2023. It's quite a monster of an edition as is spans the last 4 weeks of content. First off
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. 💻