Power BI Weekly Newsletter Issue #246

powered by endjin

If you have any content you'd like to contribute to the newsletter, please tweet @PowerBIWeekly or ping an email to PowerBIWeekly@endjin.com.

Interested in Azure? Sign up to our sibling newsletter Azure Weekly to receive all the week's Azure news.

@edfreeman_ | @endjin
powerbiweekly.info | endjin.com

Data Prep

Covering: Power Query (M), Dataflows, Data connectors, AI Insights

• Chandeep Chhabra (@chandeep2786) describes How to Trigger Dynamic and Fixed Rankings in Power BI
• Hafeez Jimoh (@jimohhafeezco) shares a few blogs: Getting Data from Excel File with multiple sheets into Power BI, Fundamental Principles of Cleaning Dirty Data in Power BI, This is how to clean Dirty Data using Power Query and Creating Calendar Table with Power Query in Power BI
• Hima Bindu Marri (@sivahimabindu) talks about Adding additional rows to existing data in Power BI Power BI for beginners

Data Modeling

Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models

• On the Power BI blog, Zoe Douglas (@MSPowerBI) announces Improvements for creating new Direct Lake semantic models and describes how to Generate measure descriptions with Copilot (preview)
• On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) delves into Optimizing time intelligence in DirectQuery
• Reid Havens (@HavensBI) describes (Case Study) Field Parameters or Calculation Groups?
• Kevin Chant (@kevchant) writes about T-SQL Tuesday 171 – Using SemPy to view DAX in Microsoft Fabric
• Kim Leblanc (@lecfomasque) covers Vue de requêtes DAX : créez, modifiez et évaluez vos mesures en 5 étapes [French]
• Hafeez Jimoh (@jimohhafeezco) covers Master Data Modeling in Power BI, talks about Data Modeling Best Practice in Power BI and describes Creating Relationships in Power BI

Report Authoring and Interactivity

Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards

• On the Business Intelligist blog, Business Intelligist (@bizintelligist) blogs about Visual Calculations – Update Your PBI Desktop Now
• Miguel Félix covers Calculos Visuais e agora? (1 de 3) [Portuguese]
• Andrzej Leszkiewicz (@avatorl) discusses Power BI Magic: SVG paths in Deneb and core Power BI visuals. Draw almost anything in real time.
• On the Learning Science YouTube channel, Learning Science describes Styling options for column and bar charts in Power BI
• Arul describes Building Slicers from Existing Attributes

Deployment, Security and Operations

Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling

• Chris Webb (@cwebb_bi) writes about Query Caching In Power BI Premium
• Nandan Hegde (@nandan_hegde15) explains how to Refresh Power BI Semantic Model from MSFT Fabric Data Pipeline
• On the Power BI community blog, Ignacio Barrau (@ignacho_07) writes about [SimplePBI][Python] Copy reports (pbix) between workspaces
• Laura Graham-Brown (@Laura_GB) explains how to Create a Power BI Service Principle Profile and writes about Power Automate and Power BI Rest API
• Roland Szirmai (@BILAnalytics) describes Fully Automated Power BI Access Management Tool using Power Apps and Power Automate - Part III

General

Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs

• No content this week

Useful Links

• Power BI Maturity Scorecard - 97% of the Fortune 500 are using Power BI. Only 20% of analytics deliver business value. How do you score?
• Azure Weekly - Interested in Azure? Sign up to our sister newsletter Azure Weekly to receive all the week's Azure news
• M language reference - Official Power Query M Reference
• PowerQuery How - Alternative M Language Reference created by Rick de Groot, including improved function explanations, code formatting, practical examples and further reading
• DAX Studio - Useful open source tool for executing and analyzing DAX queries, founded by Darren Gosbell
• DAX Guide - Your go-to reference on the DAX language, created by the SQLBI team
• Power BI Visuals Reference - An exhaustive list (as of Sep. 2018) of all Power BI native & custom visuals, placed into separate categories, again created by the SQLBI team
• Report Theme Generator - A handy report theme generator created by the Power BI Tips and Tricks team
• Power BI Theme templates - Detailed Power BI Theme templates for all the native visuals, created by David Eldersveld
• Power BI from Rookie to Rock Star - Free, detailed eBook to get up and running with Power BI, written by Reza Rad
• Power BI Architecture diagram - An informative Power BI Architecture diagram, created by Dustin Ryan
• Power BI Whitepapers - A list of official Power BI whitepapers, covering Security, Premium deployment, Advanced Analytics and more