Power BI Weekly Issue 125: 14th September 2021
Just the one announcement on what has been a very quiet week, and that's an update on the preview of the Export Power BI report to file API whereby they've massively increased the limit of the volume of API requests you can make and removed the concurrent pages limitation, amongst other changes. Othwerwise this week, Chris Webb has highlighted a useful option for SQL Server connectors to Preserve Data Types With SQL Queries In Power Query, Adam Saxton has spoken about the Power BI XMLA Endpoint and why you should care, and Antriksh Sharma has described how to Sort Columns in a Matrix in Descending order with DAX and nifty use of the 'sort by column' functionality.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- Chris Webb (@cwebb_bi) describes Preserving Data Types With SQL Queries In Power Query And Power BI
- Mimoune Djouallah (@mim_djo) describes how to Share Data from a Power BI Dataset using Dataflow
- Matt Allington (@ExceleratorBI) talks about When to use Power Query/M vs Data Modelling/DAX with Ken Puls
- Soheil Bakhshi (@biinsightnz) shares a Quick Tip: Adding Leading Zero to Integer Values Padding with DAX and Power Query
- On the Enterprise DNA blog, Melissa de Korte (@_EnterpriseDNA) writes about the M Language and Power Query Editor In Power BI
- Mike Allen (@MikeAinOz) blogs about Power BI Workflows In Excel with ADLS2
- On the dev.to blog, Matt Thacker (@mthacker09) describes Working With APIs in Microsoft's Power BI
- Ruth Pozuelo Martinez (@CurbalEN) explains How to do Pagination on a REST API in Power Query (Part 1)
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) delves into Creating Column Values Distribution Report in Power BI Using Power Query
- Rick de Groot (@Rickmaurinus) describes how to Filter Column by List Items Exact Match in Power Query
- Allison Kennedy writes about Advanced Filter OR vs AND
- On the Power BI Community blog, Xiaoxin describes Some filter operations based on character functions
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- Patrick Leblanc (@GuyInACube) talks about When is a date not a date in Power BI?
- Antriksh Sharma (@AntrikshShar) describes how to Sort Columns in a Matrix in Descending order with DAX in Power BI
- On the Power BI Community blog, Greg Deckler (@GregDeckler) writes a series of blogs: Localizing the Data Model - Part 1, Part 2 and Part 3
- Matt Allington (@ExceleratorBI) talks about Variables in DAX
- On the Purple Frog Systems blog, Jeet Kainth writes about Variables in DAX
- Brian Julius writes about What Does "Variables Are Constants" Really Mean?
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses NATURALINNERJOIN, NATURALLEFTOUTERJOIN – DAX Guide and NONVISUAL – DAX Guide
- On the Power BI Tips and Tricks blog, James Bartlett shares a tool to Copy Power BI Desktop Server:Port Connection String to Clipboard
- Leila Gharani (@LeilaGharani) shares a Smart Excel Pivot Table Trick - Choose Your KPI from Slicer Excel Dashboard with DAX
- Hima Bindu Marri (@sivahimabindu) covers ParallelPeriod in Power BI
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- On the Enterprise DNA blog, Mudassir Ali blogs about Power BI Charts And Visuals Inside Charticulator
- On the Power BI community blog, Fowmy Abdulmuttalib (@ExcelFort) discusses Part-2 How To Highlight Events, Moving Average & Build Rich Tooltips In Power BI
- Bas Dohmen (@HowToPowerBI) describes Showing multiple forecasts in one chart in Power BI and talks about TopN confusion in Power BI | When the Top3 doesn't return 3 items
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) explains Drill Down and Up in Power BI
- Reid Havens (@HavensBI) describes Getting Started with Paginated Reports with Johnny Winter
- Ruth Pozuelo Martinez (@CurbalEN) describes how to Work faster in Power BI
- Ted Pattison (@TedPattison) presents Power BI Dev Camp Session 13 - Developing with Salesforce in Power BI Reports
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, Alon Baram provides the Export Power BI report to file API – Preview Update
- Adam Saxton (@GuyInACube) talks about the Power BI XMLA Endpoint: Why you should care
- Kevin Chant (@kevchant) shares a Nifty Power BI fix in Synapse Studio
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) share Episode 204 - Power BI News Update
- On the RADACAD YouTube channel, Allison Kennedy presents the Auckland Power BI user group | Collaborate and Share Power BI through Teams
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.