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
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?
Archive
Take a look at historical Power BI articles in our archive of Power BI Weekly newsletters.
Contribute Content
If you would like to contribute any content to the Power BI Weekly newsletter, please email powerbiweekly@endjin.com.