Power BI Weekly

Issue #245 - 13th February 2024

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?.

🛠️ Data Prep

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

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

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

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

On Acuity Training, Ben Richardson (@AcuityTraining) blogs about Power BI: Which Version Should I Use?