Power BI Weekly Issue 211: 13th June 2023
Another quiet week this week, but still some great content. My colleague James has written an interesting thought-piece around Copilot in Fabric/Power BI - Are You Ready to Unleash the Power of AI in Self Service Analytics? discussing the extent to which self service analytics changes as a result of this type of technology. Elsewhere, Gerhard Brueckl has joined Reid Havens discussing Power BI CI/CD, the REST API, and VS Code, showcasing an impressive Power BI VS Code extension he's built to navigate the REST API in a visual manner. Finally, Marco Russo is back with a blog and video describing the unique LINESTX function in Implementing linear regression in Power BI.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Reid Havens (@HavensBI) discusses Connecting API's with Power Query - Not so Low Code? (with Erik Svensen)
- Miguel Félix covers PBI Desktop e Power Query o que transita (ou não) [Portuguese]
- Mimoune Djouallah (@mim_djo) describes Importing Delta table from OneLake to Power BI
- On the Learning Science YouTube channel, Learning Science describes How to get data from a website in Power BI | Web scraping in Power BI
- Rick de Groot (@Rickmaurinus) describes Removing Excess Spaces Between Words in Power Query
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) describes Implementing linear regression in Power BI
- Patrick Leblanc and Emily Lisa (@GuyInACube) describe how to Use your browser to edit your Power BI dataset within Microsoft Fabric
- Gilbert Quevauvilliers (@GilbertQue) covers Creating a Hierarchy for Field Parameters for easier navigation
- On the RADACAD blog, Leila Etaati (@leila_etaati) covers Calculating the trend of a chart using DAX (smoothing moving average)
- On the SQL Server Central blog, Harris Amjad (@mssqltips) writes about Multiple Relationships on the same Table in a Power BI Data Model
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) blogs about SAMEPERIODLASTYEAR in Power BI
- On the Excel Basement YouTube channel, Rahim Zulfiqar Ali (@rahimzulfiqar) shows DAX in Power BI that shows the amount when a slicer is selected & amount disappears when unselected
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the MSSQLTips site, Harris Amjad (@mssqltips) explains How to Create a Chiclet Slicer in Power BI Desktop
- Chandeep Chhabra (@chandeep2786) explains how to Make Your Data Shine with a Custom Line Chart in Power BI
- On the phData blog, Connor Burton (@phdatainc) writes about What is Power BI Report Builder?
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Reid Havens (@HavensBI) talks about Power BI CI/CD, the REST API, and VSCode (with Gerhard Brueckl)
- Tom Martens (@tommartens68) writes Have data will travel or should I stay or should I go
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Audrée Pellerin (@lecfomasque) covers 10 étapes pour réussir votre implantation Power BI (1 de 11) [French]
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 258 - May 2023 Power BI Feature Summary
- The Knee-Deep in Tech team (@KneeDeepinTech) present Podcast episode 229
- On the endjin blog, James Broome (@jamesbroome_) discusses Copilot - Are You Ready to Unleash the Power of AI in Self Service Analytics?
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.