Power BI Weekly #245 - 13th February 2024
Power BI Weekly Newsletter Issue #245
powered by endjin
Welcome to the 245th edition of Power BI Weekly! No Power BI specific announcements this week, but a couple of relevant announcement from the Fabric side of things. The first being that Fabric Copilot pricing has been announced, so if you're interested in taking a look at how users using Copilot will affect your billing - take a read of that blog. We've been told the billing will begin on the 1st March - so if you're an admin, you probably want to get familiar with the pricing now. The other announcement is that we can now Automate CI/CD pipelines with Microsoft Fabric Git REST APIs, so git operations are no longer confined to the Fabric UI. Elsewhere this week, and sticking to the Fabric + Power BI theme, Patrick Leblanc has answered the questions many of you may have been wondering if you've been using Lakehouses & Default Semantic Models within your tenant: Why can’t I edit my Power BI semantic model? and Adding a column to your Lakehouse? Where is it in the Semantic Model?.
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) blogs about Reading Parquet Metadata In Power Query In Power BI
- Chandeep Chhabra (@chandeep2786) talks about Dynamic Column Re-Ordering in Power Query
- On the Learning Science YouTube channel, Learning Science explains How to duplicate rows in Power Query using Power BI or Excel?
- On the Excel Basement YouTube channel, Excel Basement (@ExcelBasement) writes about Fuzzy Lookup in Excel / Power BI performs Fuzzy matching of Textual Data (Add-in or Power Query)
- On Acuity Training, Ben Richardson (@AcuityTraining) shares a number of blogs: Loading Multiple Files From A Folder Into Power BI, Pivot and Unpivot Columns in Power BI, Power BI – Custom Columns and Introduction to Automated Machine Learning In Microsoft Power BI
- Hafeez Jimoh (@jimohhafeezco) describes Getting Data in Power BI and shares a Simple Guide on getting Data in Power BI Desktop
- On the PowerPivotPro blog, P3 Adaptive (@P3Adaptive) describes How Do I Connect Power BI to a SharePoint Folder And List?
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Patrick Leblanc (@GuyInACube) talks about Why can’t I edit my Power BI semantic model? and talks about Adding a column to your Lakehouse? Where is it in the Semantic Model?
- Max Wikström (@maxwiks) describes how to Extract Measures and other Metadata from Power BI Semantic Models Using DAX
- Reid Havens (@HavensBI) walks through Testing Your Code Using the [DAX] Query View
- Henk Vlootman (@Henk4Excel) explains how to Become A Power BI Power User With DAX
- On Acuity Training, Ben Richardson (@AcuityTraining) describes Recreating Sum If In Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Martin Schoombee (@MartinSchoombee) describes how to Copy a report page from one Power BI Desktop file to another
- Pat Mahoney (@mahoneypa) shares More On Field Parameters With The Deneb Visual
- Carl de Souza (@carldesouza) discusses Embedding a Dataverse Power Automate Flow Inside Power BI
- On Acuity Training, Ben Richardson (@AcuityTraining) describes How to Export From Power BI to Excel and writes about Power BI Report Builder
- APK describes How to enable repeat header in all pages of SSRS report/Power BI report builder
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Fabric blog, Noam Raveh (@MSPowerBI) describes how to Automate your CI/CD pipelines with Microsoft Fabric Git REST APIs
- Also on the Fabric blog, Ruixin Xu announces Fabric Copilot pricing
- On the Prologika blog, Teo Lachev (@tlachev) writes about Know Thyself: Power BI Source Control
- On the Kohera blog, Kohera (@Kohera_be) discusses Updating your Azure SQL server OAuth2 credentials in Power BI via PowerShell for automation purposes
- On Acuity Training, Ben Richardson (@AcuityTraining) writes about Dynamic Row Level Security in Power BI
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On Acuity Training, Ben Richardson (@AcuityTraining) blogs about Power BI: Which Version Should I Use?
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
Power BI Weekly #243 - 30th January 2024
Tuesday, January 30, 2024
Power BI Weekly Newsletter Issue #243 powered by endjin Welcome to the 243rd edition of Power BI Weekly! This week we have just the one "official" announcement, and that's the Power BI
☁️ Azure Weekly #451 - 28th January 2024
Sunday, January 28, 2024
Azure Weekly Newsletter Issue #451 powered by endjin Welcome to issue 451 of Azure Weekly. Highlights from this edition: first up in AI: LangChain Prompt Templates with OpenAI LLMs and Enable GPT
Power BI Weekly #242 - 23rd January 2024
Tuesday, January 23, 2024
Power BI Weekly Newsletter Issue #242 powered by endjin Welcome to the 242nd edition of Power BI Weekly! A handful of announcements this week. Firstly, there is a brand New Fabric certification (Beta)
Power BI Weekly #240 - 9th January 2024
Tuesday, January 9, 2024
Power BI Weekly Newsletter Issue #240 powered by endjin Welcome to the 240th edition of Power BI Weekly! Nothing official this week - so straight onto the highlighted articles. Firstly, Kurt Buhler has
Power BI Weekly #239 - 2nd January 2024
Tuesday, January 2, 2024
Power BI Weekly Newsletter Issue #239 powered by endjin Welcome to the 239th edition of Power BI Weekly, and the first of 2024! In this newsletter we're covering all content since the last edition,
You Might Also Like
When accelerator dreams become company nightmares
Thursday, May 2, 2024
Plus: Illinois gives Rivian incentives and AI is not SaaS View this email online in your browser By Christine Hall Thursday, May 2, 2024 Hello, and welcome back to TechCrunch PM. We have a great lineup
📱 Issue 409 - Claude Team plan and iOS app
Thursday, May 2, 2024
This week's Awesome iOS Weekly Read this email on the Web The Awesome iOS Weekly Issue » 409 Release Date May 02, 2024 Your weekly report of the most popular iOS news, articles and projects Popular
💻 Issue 415 - Hotel WiFi JavaScript Injection (2012)
Thursday, May 2, 2024
This week's Awesome JavaScript Weekly Read this email on the Web The Awesome JavaScript Weekly Issue » 415 Release Date May 02, 2024 Your weekly report of the most popular JavaScript news, articles
💎 Issue 415 - Choosing the Right Audit Trail Approach in Ruby
Thursday, May 2, 2024
This week's Awesome Ruby Newsletter Read this email on the Web The Awesome Ruby Newsletter Issue » 415 Release Date May 02, 2024 Your weekly report of the most popular Ruby news, articles and
💻 Issue 408 - Speeding up C++ build times
Thursday, May 2, 2024
This week's Awesome .NET Weekly Read this email on the Web The Awesome .NET Weekly Issue » 408 Release Date May 02, 2024 Your weekly report of the most popular .NET news, articles and projects
💻 Issue 415 - Ditch dotenv: Node.js Now Natively Supports .env File Loading
Thursday, May 2, 2024
This week's Awesome Node.js Weekly Read this email on the Web The Awesome Node.js Weekly Issue » 415 Release Date May 02, 2024 Your weekly report of the most popular Node.js news, articles and
💻 Issue 333 - React 19 Beta
Thursday, May 2, 2024
This week's Awesome React Weekly Read this email on the Web The Awesome React Weekly Issue » 333 Release Date May 02, 2024 Your weekly report of the most popular React news, articles and projects
📱 Issue 412 - The Composable Architecture: My 3 Year Experience
Thursday, May 2, 2024
This week's Awesome Swift Weekly Read this email on the Web The Awesome Swift Weekly Issue » 412 Release Date May 02, 2024 Your weekly report of the most popular Swift news, articles and projects
💻 Issue 410 - Lessons learned after 3 years of fulltime Rust game development, and why we're leaving Rust behind
Thursday, May 2, 2024
This week's Awesome Rust Weekly Read this email on the Web The Awesome Rust Weekly Issue » 410 Release Date May 02, 2024 Your weekly report of the most popular Rust news, articles and projects
📺 How to Stop Any Smart TV From Spying On You — Single Player Games That Are Fun With Friends
Thursday, May 2, 2024
Also: Alienware's Latest Gaming Laptop is Great For Work, and More! How-To Geek Logo May 2, 2024 Did You Know The voice actors behind Mickey and Minnie Mouse throughout the 1980s, 1990s, and most