Power BI Weekly #190 - 17th January 2023
Power BI Weekly Newsletter Issue #190
powered by endjin
Welcome to the 190th edition of Power BI Weekly! This week we've been told about the Power BI in Microsoft Teams collaboration experiences improvements, with the preview cards getting a spruce up, along with the addition of a new embedded feedback button and the option to upgrade legacy Power BI tabs to the new version. Talking of M365 integrations, we've also been given an update on the Viva Goals + Metrics integration alongside a summary of the usability improvements that have been added to the Metrics feature. Otherwise this week, Just Blindbæk has described how to Query Power BI tenant metadata with Synapse Serverless SQL, Brian Julius has described How To Debug With SELECTEDVALUE Optional Parameter In Power BI, and Marc Lelijveld has written about How to make your Power BI solution support multiple languages.
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 sister 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
- Brian Julius (@_EnterpriseDNA) explains How To Write And Debug M Code More Effectively
- Gilbert Quevauvilliers (@GilbertQue) blogs about Updating your Query syntax in Power Query to show the entire query in M
- On the Power BI community blog, Vijay Verma describes Exact Match XLOOKUP/VLOOKUP in Power Query
- Maxim Zelensky (@Hohlick) covers Power Query Record as Dictionary: Part 2
- Chris Webb (@cwebb_bi) covers Using OData.Feed And The Query Option To Avoid The Dynamic Data Sources Error In Power BI
- Kim Leblanc covers Ajouter une ligne avec Power Query [French]
- Sam McKay (@_EnterpriseDNA) explains How To Use Query Parameter In Power BI [2023 Update] and on the Enterprise DNA blog, writes about Power BI Dataflows And Why They Are Important
- Ruth Pozuelo Martinez (@CurbalEN) explains How to connect to a SOAP API in Power BI/ Power Query
- On the MSSQLTips site, Temidayo Omoniyi (@mssqltips) explains how to Connect Power BI to Azure Data Lake Gen2 Storage for Reporting
- Gaelim Holland (@_EnterpriseDNA) delves into Classification Models In Power BI Using Python - Logistic Regression and Gradient Boost
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Marc Lelijveld (@MarcLelijveld) describes How to make your Power BI solution support multiple languages
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) discuss UNION DAX Function Vs Power Query and describe DAX CALCULATETABLE Vs FILTER Function
- Brian Julius (@_EnterpriseDNA) explains How To Debug With SELECTEDVALUE Optional Parameter In Power BI
- Sam McKay (@_EnterpriseDNA) covers Showcasing Trends Using Moving Average Techniques In Power BI [2023 Update]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Carly Newsome (@MSPowerBI) shares Announcing: Viva Goals + Metrics integration, scorecard time zones and more
- On the Learning Science YouTube channel, Learning Science describes how to Create a Q&A visual in a report in Power BI
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) explains How to work with web information, maps, and images in Power BI
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) write Visual Tooltips in Power BI
- Miguel Félix covers Tooltip baseada em contexto [Portuguese]
- On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) explains how to Enhance Your Report With The Laws Of UX
- Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) covers Paginated Reports: Sort & Filter A Bar Chart
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power BI Administrator Tenant Settings and Admin Portal and on the RADACAD YouTube channel, shares Power BI Licensing Ultimate Guide
- Just Blindbæk (@justblindbaek) describes how to Query Power BI tenant metadata with Synapse Serverless SQL
- Ignacio Barrau (@ignacho_07) covers [PowerBiReportServer] Usar API para copiar informe a Service [Spanish]
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, Lukasz Pawlowski (@lukasztweets) announces Power BI in Microsoft Teams collaboration experiences improvements
- Also on the Power BI blog, Kelly Kaye (@MS_KellyKaye) shares Thank You Power BI Community
- The Power BI team (@MSPowerBI) shares Ignite feature deep dive: B2B sharing, SharePoint Integration, Optimize ribbon, and more
- Kevin Chant (@kevchant) shares Recommended certifications for Power BI enthusiasts
- On the SQL Shack blog, Daniel Calbimonte (@dcalbimonte) describes How to create Power BI reports
- Bas Dohmen (@HowToPowerBI) describes how to Start creating a Power BI report in less than 1 minute
- Nicky van Vroenhoven (@NickyvV) covers Power BI 2022 In Review: My Favourite Features
- Reid Havens (@HavensBI) discusses ChatGPT (Fad or Future?) - Practical use-cases for Power BI (with Mathias Halkjær)
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 #400 - 18th December 2022
Sunday, December 18, 2022
Azure Weekly Newsletter Issue #400 powered by endjin Welcome to issue 400 of Azure Weekly 🎉 It's quite mind-boggling that we've reached this milestone. When I published the first issue on 2nd
☁️ Azure Weekly #399 - 11th December 2022
Sunday, December 11, 2022
Azure Weekly Newsletter Issue #399 powered by endjin Welcome to issue 399 of the Azure Weekly Newsletter. A mixed bag this week. First up, Synapse – Data Lake vs. Delta Lake vs. Data Lakehouse and
☁️ Azure Weekly #398 - 4th December 2022
Sunday, December 4, 2022
Azure Weekly Newsletter Issue #398 powered by endjin Welcome to issue 398 of the Azure Weekly Newsletter. There's a bit of a melting pot of news and articles this week. Items of note around
Power BI Weekly #184 - 29th November 2022
Tuesday, November 29, 2022
Power BI Weekly Newsletter Issue #184 powered by endjin Welcome to the 184th edition of Power BI Weekly! Absolutely no word from the Power BI team this week, so we'll jump straight into the
☁️ Azure Weekly #395 - 13th November 2022
Sunday, November 13, 2022
Azure Weekly Newsletter Issue #395 powered by endjin Welcome to issue 395 of Azure Weekly. This week saw the release of .NET 7.0 and day zero support across Azure PaaS services, including App Service,
You Might Also Like
Your 3 AI Incubator Tracks: Curriculum, Coaching, or 1-on-1 Mentorship
Friday, April 19, 2024
How to pick the one that's right for you
Logitech's AI Prompt Builder is surprisingly handy
Friday, April 19, 2024
Torvalds on evil devs and AI hype; Quest 2's price drops; Virtual cards explained -- ZDNET ZDNET Tech Today - US April 19, 2024 placeholder Logitech's free AI Prompt Builder is surprisingly
Tesla recalls nearly 4,000 Cybertrucks
Friday, April 19, 2024
After reports of malfunctioning accelerator pedals, Tesla is recalling Cybertrucks View this email online in your browser By Alex Wilhelm Friday, April 19, 2024 Welcome to TechCrunch AM! Today's
SWLW #595: My role as a founder CTO, AI Product Management, and more.
Friday, April 19, 2024
Weekly articles & videos about people, culture and leadership: everything you need to design the org that makes the product. A weekly newsletter by Oren Ellenbogen with the best content I found
The bill to ban TikTok is barreling ahead
Friday, April 19, 2024
The Morning After It's Friday, April 19, 2024. The bill that could ban TikTok in the United States inches closer to becoming law. The legislation passed the House of Representatives last month,
Digest #134: TDD with Serverless, Terraform AI Conversions, K8s Cost Metrics & OpenTofu Response
Friday, April 19, 2024
Learn to convert Terraform templates, deploy SSR on AWS Amplify, and apply TDD to Serverless. Gain insights on PostgreSQL, microfrontends, and secure APIs. ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Akira Ransomware Gang Extorts $42 Million; Now Targets Linux Servers
Friday, April 19, 2024
THN Daily Updates Newsletter cover Webinar -- The Future of Threat Hunting Is Powered by Generative AI From Data to Defense: Step Into the Next Era of Cybersecurity with CensysGPT Download Now
ASP.NET Core News - 04/19/2024
Friday, April 19, 2024
View this email in your browser Get ready for this weeks best blog posts about ASP.NET Core! This newsletter is sponsored by elmah.io - the most advanced, yet so simple to set up, error logging and
Post from Syncfusion Blogs on 04/19/2024
Friday, April 19, 2024
New blogs from Syncfusion Syncfusion Prepares for MS Build 2024 with Cloud-Ready Solutions on Azure Marketplace By gingerr Syncfusion offers cloud-ready solutions in Azure Marketplace for MS Build 2024
Hacker Newsletter #696
Friday, April 19, 2024
The greatest value of a picture is when it forces us to notice what we never expected to see. //John W. Tukey hackernewsletter Issue #696 // 2024-04-19 // View in your browser #Favorites Unlock your