Power BI Weekly
Issue #262 - 11th June 2024
Quite a short one this week. The only announcement is that we can now Ask Copilot questions against your semantic model (Preview) to get quick answers to simple analytical questions you have about the data in your model. The reason I say "simple" is that the more involved the query is, the more likely that the result won't quite be what you expect (obviously). However, Chris Webb has written a brilliant blog about how to Get Better Results From Power BI Copilot With Linguistic Modelling, showing the importance of having a model following Power BI star schema recommended practices, but also showing how important naming is, and how Power BI can help you help Copilot query your data more effectively. I certainly learned a couple of things reading that blog!
Elsewhere this week, Sam McKay has recorded an interesting video titled My Power BI workflow for 2024. Energy dataset. ChatGPT augmentation of work, giving a taste of what a standard report development process looks for him these days, what with the presence of generative AI opening up so many opportunities. And sticking with report design - Kurt Buhler has introduced the 3-30-300 rule for better reports, giving some handy tips on how to create clear and effective reports/dashboards.
🛠️ Data Prep
- Chandeep Chhabra (@chandeep2786) explains how to Combine Data from Multiple PDFs with Inconsistent Column Names
- Olivier Travers (@otravers) describes Connecting to Fabric Lakehouse, Warehouse, Power BI Datamart, and PowerApps Dataverses SQL Server from Desktop Tools and External Services
- Rick de Groot (@Rickmaurinus) writes about Using Custom Comparers with Table.Group in Power Query
🧩 Data Modeling
- On the Power BI blog, Rien Hu (@MSPowerBI) announces Ask Copilot questions against your semantic model (Preview)
- Chris Webb (@cwebb_bi) explains how to Get Better Results From Power BI Copilot With Linguistic Modelling
- Patrick Leblanc (@GuyInACube) explains how to Reframe your Power BI Direct Lake Semantic Model
- On the Learning Science YouTube channel, Learning Science describes How to create a bin in Power BI
- Reid Havens (@HavensBI) talks about Comparing Performance Analyzer Data (After Page Optimization)
📊 Report Authoring and Interactivity
- On the SQLBI blog, Kurt Buhler (@kurtbuhler) covers Introducing the 3-30-300 rule for better reports
- Roland Szirmai (@BILAnalytics) talks about Expression-based Titles in Power BI and How To Fix the Interaction on Visual Elements
🚀 Deployment, Security and Operations
- Adam Saxton (@GuyInACube) explains how to Update Data Sources within Deployment Pipelines