Power BI Weekly Issue 244: 6th February 2024
This week the biggest news is that the VNet Data Gateway for Fabric and Power BI is now Generally Available, which currently supports Fabric Dataflows Gen2, Power BI Semantic Models, Power Platform Dataflows, and Power BI Paginated Reports. I know this has been a common request from many organizations, so I'm sure this is welcome news for a lot of you! We've also been told about the New Solution Accelerators for Power BI Embedded Analytics for those of you embedding reports into custom apps, and for those of you working in regulated industries, you'll be glad to hear that Microsoft Fabric is now HIPAA compliant amongst gaining certifications for various ISO standards.
Elsewhere this week, Paul Turley has written a detailed blog about CI/CD & DevOps for Power BI… Are We There Yet? and Chris Webb has shed some light on Performance Implications Of Using Calculated Columns In Composite Models On Power BI Semantic Models (be very careful!)
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chandeep Chhabra (@chandeep2786) describes List.Accumulate Case Study in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Chris Webb (@cwebb_bi) writes about Performance Implications Of Using Calculated Columns In Composite Models On Power BI Semantic Models
- Eugene Meidinger (@sqlgene) shares a set of videos on Power BI Performance Tuning
- Patrick Leblanc (@GuyInACube) discusses Power BI Tips: Excluding Top N with DAX
- On the SQLBI blog, Marco Russo (@marcorus) covers Differences between DATEADD and PARALLELPERIOD in DAX
- Max Wikström (@maxwiks) writes about Using variables in DAX
- Pat Mahoney (@mahoneypa) describes how to Use Calculation Groups to Get Default Selections and/or Protect Your Fabric Capacity
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Bas Dohmen (@HowToPowerBI) talks about 5 Design Mistakes to Avoid in Power BI
- Reid Havens (@HavensBI) covers Avoiding Hidden Visual-Level Filters with Field Parameters
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) write about Power BI Slicer Search: User Guide With Examples
- Bernat Agulló Roselló (@AgulloBernat) describes Reversing selection on a slicer (sort of)
- On the Learning Science YouTube channel, Learning Science explains How to add data labels to the end of a line chart in Power BI?
- Andrzej Leszkiewicz (@avatorl) describes Embedding Vega data visualization into a Power BI report using the Deneb custom visual
- Roland Szirmai (@BILAnalytics) writes about Data-Driven Data Visualization in Power BI - How to Use Science to Create More Impactful DataViz
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the Power BI blog, Nikki Waghani (@NikkiWaghani) announces VNet Data Gateway for Fabric and Power BI is now Generally Available
- On the Power BI blog, Ofer Ashkenazi (@MSPowerBI) announces Accelerating Embedded Analytics for Your Application
- Paul Turley (@paul_turley) covers CI/CD & DevOps for Power BI… Are We There Yet?
- Adam Saxton (@GuyInACube) describes how to Use Source Control with your Power BI Report in Microsoft Fabric
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Power BI blog, Kimberly Williams announces that Microsoft Fabric is now HIPAA compliant
- Chris Webb (@cwebb_bi) writes about Learning Power BI And Fabric By Attending User Groups And Conferences
- Hafeez Jimoh (@jimohhafeezco) provides An Introduction to Power BI: What You Need to Know and provides an Overview of the Power BI Desktop Interface
- Dhruvin Shah (@DhruvinShah16) talks about What is Fabric? Will it Replace Power BI? Ft. Chris Webb
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Microsoft Fabric / Power BI Q&A (Feb 3, 2023)
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.