Power BI Weekly Issue 155: 3rd May 2022
Some really cool news is that Analyze in Excel Workbooks are now saved to OneDrive for Business, which helps lower the barrier to entry even further for Excel users consuming Power BI datasets, especially those potentially using alternative OSs. We've also been told about the updates around High availability, load balancing and troubleshooting for the Vnet gateway.
Elsewhere this week, Antriksh Sharma has described some interesting Complex behaviour of slicers in Power BI, Meagan Longoria has shared some handy Viridis color palettes in Power BI theme files, and Kelly Kaye has hosted The Power BI Community Show Ep 3 - talking about Known Issues, Reports & Visuals, and Power BI Certifications with guests Michele Hart, Reid Havens and Shannon Lindsay.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) covers The Power Query XML Functions, Missing Or Null Values And Inconsistent Schema Inference
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses PL-300: Power BI Exam Prep: Connecting to data sources
- Chandeep Chhabra (@chandeep2786) describes how to Extract Any Step in Power Query
- James Andrew describes Six Simple Tips to Improve Your Power Query Efficiency within Power BI & Excel
- Bas Dohmen (@HowToPowerBI) describes How to use the Google Geocoding API in Power BI Quickly find Longitude and Latitude Coordinates
- On the Learning Science YouTube channel, Learning Science covers Language Detection in Power BI - Using AI Insights
- Reid Havens (@HavensBI) describes How To Quickly Add Notes In Power Query
- The Azure updates team writes about General availability: Azure Cosmos DB portal—Azure Synapse Link seamless Power BI
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) discusses Creating Tables in Power BI
- Ruth Pozuelo Martinez (@CurbalEN) shares 2 Free Cheat Sheets for Power BI
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes about Custom Columns In Power BI Vs. Conditional Columns
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Marco Russo (@marcorus) writes About waiting time for Power BI Desktop to open
- Also on the SQLBI blog, Alberto Ferrari (@FerrariAlberto) describes Introducing CALCULATE in DAX, talks about BETA.DIST, BETA.INV – DAX Guide and covers COMBIN, COMBINA – DAX Guide
- Antriksh Sharma (@AntrikshShar) describes the Complex behaviour of slicers in Power BI and on the Enterprise DNA blog, explains how to Connect DAX Studio To Power BI And SSAS
- Mimoune Djouallah (@mim_djo) talks about Tableau vs Power BI behavior in DirectQuery Mode , Result Cache
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) explains how to Create a Folder Measure and Folder Fields in Power BI desktop
- Daniil Maslyuk (@DMaslyuk) shares Power BI Antipatterns #8: Unformatted DAX
- On the Power BI Community blog, Polly Pu describes How to calculate about Matrix subtotal
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Ikechukwu Edeagu writes that Analyze in Excel Workbooks are now saved to OneDrive for Business
- Meagan Longoria (@mmarie) shares some Viridis color palettes in Power BI theme files
- Avi Singh (@powerbipro) describes How to Create Aging Reports by Bins/Buckets (Showing Open/Overdue Items)
- Soheil Bakhshi (@biinsightnz) writes about Thin Reports, What Are They, Why Should I Care and How Can I Create Them?
- Bas Dohmen (@HowToPowerBI) shares a Financial Statement Template Approach in Power BI and talks about Run to the MVP
- On LaDataWeb, Ignacio Barrau (@ignacho_07) describes how to Documentar informes con tooltips [Spanish]
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, Miquella de Boer (@MSPowerBI) announces High availability, load balancing and troubleshooting the Vnet gateway
- Patrick Leblanc (@GuyInACube) talks about Row-Level Security and Object-Level Security together in Power BI
- Marc Lelijveld (@MarcLelijveld) blogs about Sharing individual Power BI dataflows, but how?
- Gilbert Quevauvilliers (@GilbertQue) writes about Which Power BI Reports do I have access to? – Part 3 – Creating the "Power BI Users Reports List" report
- Rick de Groot (@Rickmaurinus) walks through Comparing Licenses in Power BI
- James Serra (@JamesSerra) discusses Power BI Performance Features
- On the Microsoft BI Tools blog, Joost van Rossum (@ssisjoost) explains how to Refresh Power BI Datasets with ADF or Synapse MSI
- On the Enterprise DNA blog, Antriksh Sharma (@AntrikshShar) describes How To Install SQL Server For Power BI
- On the Power BI Tips and Tricks blog, Steve Campbell (@PowerBISteve) discusses a Power BI Support Channel: Microsoft Teams Tips
- On the RADACAD YouTube channel, Leila Etaati (@leila_etaati) talks about Power BI goals, How to set settings and how to set Values
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- Dhruvin Shah (@DhruvinShah16) hosts a user group event: Developing Power BI Reports with PBI Tools with Mathias Thierbach
- Microsoft Power BI (@MSPowerBI) hosts The Power BI Community Show Ep 3 - Known Issues, Reports & Visuals, and Power BI Certifications
- Reid Havens (@HavensBI) presents Why Power BI Community Rocks with Nikola Ilic
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) presents Live Power BI Q&A with RADACAD - 2022-04-29
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.