Power BI Weekly Issue 190: 17th January 2023
This week we've been told about the Power BI in Microsoft Teams collaboration experiences improvements, with the preview cards getting a spruce up, along with the addition of a new embedded feedback button and the option to upgrade legacy Power BI tabs to the new version. Talking of M365 integrations, we've also been given an update on the Viva Goals + Metrics integration alongside a summary of the usability improvements that have been added to the Metrics feature. Otherwise this week, Just Blindbæk has described how to Query Power BI tenant metadata with Synapse Serverless SQL, Brian Julius has described How To Debug With SELECTEDVALUE Optional Parameter In Power BI, and Marc Lelijveld has written about How to make your Power BI solution support multiple languages.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Brian Julius (@_EnterpriseDNA) explains How To Write And Debug M Code More Effectively
- Gilbert Quevauvilliers (@GilbertQue) blogs about Updating your Query syntax in Power Query to show the entire query in M
- On the Power BI community blog, Vijay Verma describes Exact Match XLOOKUP/VLOOKUP in Power Query
- Maxim Zelensky (@Hohlick) covers Power Query Record as Dictionary: Part 2
- Chris Webb (@cwebb_bi) covers Using OData.Feed And The Query Option To Avoid The Dynamic Data Sources Error In Power BI
- Kim Leblanc covers Ajouter une ligne avec Power Query [French]
- Sam McKay (@_EnterpriseDNA) explains How To Use Query Parameter In Power BI [2023 Update] and on the Enterprise DNA blog, writes about Power BI Dataflows And Why They Are Important
- Ruth Pozuelo Martinez (@CurbalEN) explains How to connect to a SOAP API in Power BI/ Power Query
- On the MSSQLTips site, Temidayo Omoniyi (@mssqltips) explains how to Connect Power BI to Azure Data Lake Gen2 Storage for Reporting
- Gaelim Holland (@_EnterpriseDNA) delves into Classification Models In Power BI Using Python - Logistic Regression and Gradient Boost
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Marc Lelijveld (@MarcLelijveld) describes How to make your Power BI solution support multiple languages
- On the Enterprise DNA blog, Enterprise Dna Experts (@EnterpriseDNA) discuss UNION DAX Function Vs Power Query and describe DAX CALCULATETABLE Vs FILTER Function
- Brian Julius (@_EnterpriseDNA) explains How To Debug With SELECTEDVALUE Optional Parameter In Power BI
- Sam McKay (@_EnterpriseDNA) covers Showcasing Trends Using Moving Average Techniques In Power BI [2023 Update]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Power BI blog, Carly Newsome (@MSPowerBI) shares Announcing: Viva Goals + Metrics integration, scorecard time zones and more
- On the Learning Science YouTube channel, Learning Science describes how to Create a Q&A visual in a report in Power BI
- On the SQL Server Central blog, Daniel Calbimonte (@dcalbimonte) explains How to work with web information, maps, and images in Power BI
- On the Select Distinct blog, Simon Harrison (@SelectDistLtd) write Visual Tooltips in Power BI
- Miguel Félix covers Tooltip baseada em contexto [Portuguese]
- On the Enterprise DNA blog, Alexandru Badiu (@BadiuAlexandru) explains how to Enhance Your Report With The Laws Of UX
- Also on the Enterprise DNA blog, Sue Bayes (@sue_bayes) covers Paginated Reports: Sort & Filter A Bar Chart
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- On the RADACAD blog, Reza Rad (@Rad_Reza) discusses Power BI Administrator Tenant Settings and Admin Portal and on the RADACAD YouTube channel, shares Power BI Licensing Ultimate Guide
- Just Blindbæk (@justblindbaek) describes how to Query Power BI tenant metadata with Synapse Serverless SQL
- Ignacio Barrau (@ignacho_07) covers [PowerBiReportServer] Usar API para copiar informe a Service [Spanish]
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, Lukasz Pawlowski (@lukasztweets) announces Power BI in Microsoft Teams collaboration experiences improvements
- Also on the Power BI blog, Kelly Kaye (@MS_KellyKaye) shares Thank You Power BI Community
- The Power BI team (@MSPowerBI) shares Ignite feature deep dive: B2B sharing, SharePoint Integration, Optimize ribbon, and more
- Kevin Chant (@kevchant) shares Recommended certifications for Power BI enthusiasts
- On the SQL Shack blog, Daniel Calbimonte (@dcalbimonte) describes How to create Power BI reports
- Bas Dohmen (@HowToPowerBI) describes how to Start creating a Power BI report in less than 1 minute
- Nicky van Vroenhoven (@NickyvV) covers Power BI 2022 In Review: My Favourite Features
- Reid Havens (@HavensBI) discusses ChatGPT (Fad or Future?) - Practical use-cases for Power BI (with Mathias Halkjær)
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.