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