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
Re: You're Invited: Free Photo Management Class
Tuesday, March 11, 2025
This is your last chance to register for tomorrow's live online Photo Management Class, Wednesday, March 12, at 4:30 pm ET! Sign up now to attend the FREE Photo Management Class The recent changes
BetterDev #275 - Tracking You from a Thousand Miles Away! Turning a Bluetooth Device into an Apple AirTag Without Root Privileges
Monday, March 10, 2025
Better Dev #275 Mar 10, 2025 Hi all, In the wave of ByBit exchange being hack for 1.6billion, and the hack is very sophisciated, exploit developer access key to change an s3 bucket. The attack start by
What's the goal of the goal & Tapbots is working on a Bluesky client
Monday, March 10, 2025
Capacities releases rewritten PDF viewer and new AI editor, Ghost teases larger update for its ActivityPub integration, clear communication, and more in this week's issue of Creativerly.
Ranked: | The World's Most Popular Programming Languages 🖥️
Monday, March 10, 2025
In 2024, Python surpassed JavaScript as the most popular programming language on GitHub for the first time. View Online | Subscribe | Download Our App Invest in your growth at Exchange 2025. FEATURED
GCP Newsletter #441
Monday, March 10, 2025
Welcome to issue #441 March 10th, 2025 News Infrastructure Official Blog Hej Sverige! Google Cloud launches new region in Sweden - Google Cloud has launched its 42nd cloud region in Sweden, providing
⚡ THN Weekly Recap: New Attacks, Old Tricks, Bigger Impact
Monday, March 10, 2025
State-sponsored hacking, IoT botnets, ransomware shifts—this week's cyber roundup covers it all. Stay informed, stay secure. Read now ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏ ͏
Beware AI voice cloning tools 🤖
Monday, March 10, 2025
Linux for your phone; Warner Bros. DVDs rot; GCal gets Gemini -- ZDNET ZDNET Tech Today - US March 10, 2025 Voice waveforms Most AI voice cloning tools aren't safe from scammers, Consumer Reports
⚙️ Google's AI plans
Monday, March 10, 2025
Plus: The DeepSeek alarm bells
Post from Syncfusion Blogs on 03/10/2025
Monday, March 10, 2025
New blogs from Syncfusion ® Convert PowerPoint to PDF in C# Using Advanced Formatting Options By Mohanaselvam Jothi Learn how to convert PowerPoint presentations to PDF with advanced options using the
😎 10 Weirdest Android Phones Ever — Why I Prefer Bixby to Google Assistant
Monday, March 10, 2025
Also: 3 Awesome Shows to Watch After "Fallout", and More! How-To Geek Logo March 10, 2025 Did You Know Despite their dog-like appearance, hyenas are more similar, phylogenetically speaking,