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
Spyglass Dispatch: A New Social Media?
Thursday, December 19, 2024
No 'Apple Prime' • RIP David Bonderman • Cable Is Now Sports • Apple v. Meta v. Europe • Glimpse of Superman The Spyglass Dispatch is a newsletter sent on weekdays featuring links and
Issue 344 - FSD v13.2.1 update rolls out to Cybertruck and HW4 owners
Thursday, December 19, 2024
View this email in your browser If you are just now finding out about Tesletter, you can subscribe here! If you already know Tesletter and want to support us, check out our Patreon page Issue 344 - FSD
Programmer Weekly - Issue 236
Thursday, December 19, 2024
View this email in your browser Programmer Weekly Welcome to issue 236 of Programmer Weekly. This is the final issue of 2024. We will be back after the holiday break. Wish you and your family Happy
Web Tools #596 - React Tools, AI Tools, Jamstack, Eleventy
Thursday, December 19, 2024
WEB VERSION Issue #596 • December 19, 2024 Advertisement WorkOS: Modern Identity Platform for B2B SaaS With WorkOS you can start selling to enterprises with just a few lines of code. WorkOS provides a
Heres Why High Achievers Feel Like Failures
Thursday, December 19, 2024
Top Tech Content sent at Noon! The $189B VR Gaming Revolution is Here – Invest in AEXLAB Read this email in your browser How are you, @newsletterest1? 🪐 What's happening in tech today, December 19,
Python Weekly - Issue 681
Thursday, December 19, 2024
View this email in your browser Python Weekly Welcome to issue 681 of Python Weekly. This is the final issue of 2024. We will be back after the holiday break. Wish you and your family Happy Holidays!
Dev Vexed by Copilot Refusal, Versioning ASP.NET Core Services, OpenSilver Drag-and-Drop XAML, More
Thursday, December 19, 2024
Home | News | How To | Webcasts | Whitepapers | Advertise .NET Insight December 19, 2024 THIS ISSUE SPONSORED BY: ■ Yes, you finally test like a champion. ■ dtSearch® - INSTANTLY SEARCH TERABYTES
The 4 easiest ways to test Linux
Thursday, December 19, 2024
🚫 TP-Link ban; Favorite wearables of 2024; Gemini 2.0 Flash -- ZDNET ZDNET Tech Today - US December 19, 2024 VirtualBox running OpenMandriva as a guest OS. The 4 easiest ways to test Linux on your old
⚙️ AI startup secures $300 million
Thursday, December 19, 2024
Plus: Medical AI assistants
Post from Syncfusion Blogs on 12/19/2024
Thursday, December 19, 2024
New blogs from Syncfusion Vite.js: Build Faster Frontends By Nishani Dissanayake Learn how Vite.js can speed up your frontend development process with its instant server start and lightning-fast HMR.