Power BI Weekly #233 - 14th November 2023
Power BI Weekly Newsletter Issue #233
powered by endjin
Welcome to the 233rd edition of Power BI Weekly! This week the ground-breaking news is that Datasets have been renamed to semantic models. I should think this decision will divide opinion. From the Fabric perspective, this makes total sense. There are too many artifacts that resemble "datasets" in Fabric such that the term could add an annoying level of ambiguity (especially for newcomers). Conversely, looking at Power BI in isolation, "datasets" are a well-defined artifact type and can't be confused as easily with other artifacts. "Dataset" is also a well-known and understood term. "Semantic model" is less well understood as a term, but I do think it more accurately describes the role of the data model + measures in Power BI. Anyway, it will be interesting to see how the community reacts to this one!
There has been one other announcement this week, and that's the On-premises data gateway November 2023 release, which includes a new tenant registration allowlist setting which you can use to control which tenants are allowed to register the on-premises data gateway application. The final article I'd like to highlight this week has been written by my colleague Barry who has written about why Star Schemas are fundamental to unleashing value from data in Power BI and Microsoft Fabric, focusing on the business and end-user implications/justifications rather than solely the technical, and discussing where in the data pipeline lifecycle the star schema should be generated. Do have 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
- Chris Webb (@cwebb_bi) writes about Excel Workbook Layout And The Performance Of Reading Data With Power Query In Power BI
- Chandeep Chhabra (@chandeep2786) describes how to Dynamically Expand All Columns in Power Query | Power Query Trick and covers '#section' Trick in Power Query
- Rick de Groot (@Rickmaurinus) writes about Resolving Dataformat Errors in Power Query M
- Avi Singh (@powerbipro) shares a Power Query Tutorial for Beginners: Complete Step-by-Step Tutorial with Download Files
- On the Learning Science YouTube channel, Learning Science explains How to get SharePoint data into Power BI?
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the Power BI blog, Christian Wade (@_christianWade) announces Datasets renamed to semantic models
- On the endjin blog, Barry Smart (@barry_j_a_smart) writes that Star Schemas are fundamental to unleashing value from data in Microsoft Fabric
- On the SQLBI blog, Marco Russo (@marcorus) discusses Computing MTD, QTD, YTD in Power BI for the current period
- Chandeep Chhabra (@chandeep2786) talks about DAX Summarization Tricks in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Tom Martens (@tommartens68) writes about The (better) rectangular pie chart
- Bas Dohmen (@HowToPowerBI) talks about Why Your Report Needs a Box Plot and How to Build It in Power BI
- Reid Havens (@HavensBI) talks about Three Techniques for Curating the User Experience in Power BI
- Marcus Wegener (@PowerBIler) describes Display images from Business Central via the API in Power BI
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, Nikki Waghani (@NikkiWaghani) announces On-premises data gateway November 2023 release
- On the phData blog, Gavin Pedersen (@gavin_PD) describes How to Automate Switching Your Snowflake Datasource with Power BI Deployment Pipelines
- Kevin Chant (@kevchant) blogs about Power BI Project (PBIP) and Azure DevOps CI performance tests
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- The Knee-Deep in Tech team (@KneeDeepinTech) presents Podcast episode 244
- On the Power BI community blog, Dennis Carriere writes about From the Desk of An Experienced Power BI Analyst
- On the PowerPivotPro blog, Rob Collie (@robcolli3) covers Tableau VS Power BI and writes about Why Is Power BI More Popular than Tableau?
Useful Links
- Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
- 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
- PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
- 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
Older messages
☁️ Azure Weekly #444 - 12th November 2023
Sunday, November 12, 2023
Azure Weekly Newsletter Issue #444 powered by endjin Welcome to issue 444 of Azure Weekly. A short and sweet issue, as I expect a many announcements are being held back for the Microsoft Ignite
Power BI Weekly #230 - 24th October 2023
Tuesday, October 24, 2023
Power BI Weekly Newsletter Issue #230 powered by endjin Welcome to the 230th edition of Power BI Weekly! The Power BI October 2023 Feature Summary was shared last Tuesday (even though the blog
☁️ Azure Weekly #441 - 22nd October 2023
Sunday, October 22, 2023
Azure Weekly Newsletter Issue #441 powered by endjin Welcome to issue 441 of Azure Weekly. This edition contains a few new announcements, and lots of in-depth articles; highlights include: Chat your
Power BI Weekly #228 - 10th October 2023
Tuesday, October 10, 2023
Power BI Weekly Newsletter Issue #228 powered by endjin Welcome to the 228th edition of Power BI Weekly! Last week there was an announcement we're very excited by here at endjin, which is the
Power BI Weekly #227 - 3rd October 2023
Tuesday, October 3, 2023
Power BI Weekly Newsletter Issue #227 powered by endjin Welcome to the 227th edition of Power BI Weekly! A short edition this week, but there are a few updates. Not sure how I missed this one, but a
You Might Also Like
Tuesday Triage #200 and giveaway
Tuesday, May 14, 2024
Your weekly crème de la crème of the Internet is here! The 200th edition featuring annual subscriptions giveaway, thoughts on nearly four years of ...
🎮 How AI Tools Are Changing Game Development — Grab a Pixel 8a Instead of Waiting for Pixel 9
Tuesday, May 14, 2024
Also: Sharing Your Google Maps Trip Progress, and More! How-To Geek Logo May 14, 2024 Did You Know In a bid to keep the ingredients secret, WD-40 was never patented. 🤖 The New GPT It's Tuesday!
Meta shuts down Workplace
Tuesday, May 14, 2024
Plus: Everything that happened at Google I/O and AWS CEO steps down View this email online in your browser By Christine Hall Tuesday, May 14, 2024 Hello, and welcome back to TechCrunch PM. The team
Flattening Lists of Lists, Python 3.13, Sets, and More
Tuesday, May 14, 2024
Flattening a List of Lists in Python #629 – MAY 14, 2024 VIEW IN BROWSER The PyCoder's Weekly Logo Flattening a List of Lists in Python In this video course, you'll learn how to flatten a list
Daily Coding Problem: Problem #1441 [Easy]
Tuesday, May 14, 2024
Daily Coding Problem Good morning! Here's your coding interview problem for today. This problem was asked by Google. UTF-8 is a character encoding that maps each symbol to one, two, three, or four
Noonification: 3 Quick Ways to Optimize RecyclerView
Tuesday, May 14, 2024
Top Tech Content sent at Noon! Get Algolia: AI Search that understands How are you, @newsletterest1? 🪐 What's happening in tech today, May 14, 2024? The HackerNoon Newsletter brings the HackerNoon
Using 97 fewer cores thanks to PGO
Tuesday, May 14, 2024
Plus an HNSW indexed vector store library, a new Go game hits the Steam store, and is 'ok' ok?. | #507 — May 14, 2024 Unsub | Web Version Together with Stytch logo Go Weekly Reclaiming CPU for
Ranked | The Top 6 Economies by Share of Global GDP (1980-2024) 📈
Tuesday, May 14, 2024
Gain a unique perspective on the world's economic order from this graphic showing percentage share of global GDP over time. View Online | Subscribe Presented by: Data that drives the
Free online event this Thursday: Getting ahead with time series data
Tuesday, May 14, 2024
Free Online Event Do you know how your competitors use time series data to get ahead? Join us on Thursday, May 16 at 10am PT/1pm ET for a free, hour-long online fireside chat called “Unleash the Full
Here's the deal
Tuesday, May 14, 2024
We wanted you to be among the first to know about our plans to relaunch the Gigantic training courses that Product Collective now powers! Here's the deal: From May 20th - May 31st, anybody that