Power BI Weekly Issue 87: 1st December 2020
This week we've had the official announcement regarding the New export settings in the Power BI admin portal which I highlighted in the editorial last week - do check them out if you haven't already. The Power BI team has also written a blog about Moving on-premises AS and RS BI solutions to Azure - and closer to Power BI, referring to the new SSAS and SSRS VM images in the Azure Marketplace. A great stepping stone to moving solutions fully into Power BI and the cloud.
Elsewhere this week, Reza Rad has spoken about Power BI data source isolation using dataflows - How is it and what are the benefits? Gilbert Quevauvilliers has described How to enable dataset sizes larger than 10GB for Power BI Premium or Power BI Premium Per User, and finally (something fun for those of us in the UK), Alison Box has put together a comprehensive report based on "Strictly Come Dancing" Telling the Story Behind the Numbers with Power BI.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, AI Insights
- On the RADACAD YouTube channel, Reza Rad (@Rad_Reza) describes Power BI data source isolation using dataflows - How is it and what are the benefits?
- Andy Cutler (@MrAndyCutler) describes Harnessing Azure Synapse Analytics SQL Serverless in Power BI Dataflows
- Kreimir Ledinski discusses how to Split packs into single products in Power Query
- On myOnlineTraininghub, Philip Treacy (@OnlineTrainingH) writes about Dense Ranking in Power Query
- On the Towards Data Science blog, Peter Hui describes Power BI Functions—List.MaxN, R-slicemax, TOPN
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes How To Merge Queries In Power BI
- Also on the Enterprise DNA blog, Nick Mone describes Solving Missing Currency Rates With Power Query In Power BI
- Patrick Leblanc (@GuyInACube) takes A look at Visual Data Prep in Power BI dataflows
- Laura Graham-Brown (@Laura_GB) covers Power BI Dataflow – Refresh History and describes how to Create Dataflow from Export
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Get OECD API data in Power BI: Global Unemployment rates 2020
Data Modeling
Covering: DAX (Measures & Calculated Tables/Columns), Relationships, Analysis Services, Composite models
- On the SQLBI blog, Alberto Ferrari (@FerrariAlberto) discusses RANKX on multiple columns with DAX and Power BI
- On the Power BI community blog, DataZoe explains How did I format my DAX expression in a post?
- Patrick Leblanc (@GuyInACube) describes Power BI Case: Too many rows from a DAX Statement
- Reid Havens (@HavensBI) writes about Dynamic Column Headers for Time Periods in Power BI
- Dhruvin Shah (@DhruvinShah16) talks about the New Model View Updates in Power BI
- Sam Fischer describes Slicing based on OR and XOR conditions in Power BI
- Also on the Power BI Community blog, Yingying Ruan describes Dynamic calculation of YTD and ETC based on the selected month
- On Le CFO Masqué, Sophie Marchand (@Mon_Cher_Watson) describes how to Calculer un taux de croissance annuel composé (CAGR) [French]
Report Authoring and Interactivity
Covering: Layout and formatting, Visualizations, Interactivity, Themes, Mobile reports, Dashboards
- Parker Stevens (@PowerBIElite) talks about Creating a Custom Timeline Matrix in Power BI
- On the Tessellation Tech blog, Spencer Baucke (@JSBaucke) discusses Toggling Views with Bookmarks in Power BI
- On the CSG Pro blog, Warren Dean (@DataTaleAU) presents Which Way to the Right Map in Power BI
- Dhruvin Shah (@DhruvinShah16) talks about the New Field Icons in Power BI
- The Power BI team (@MSPowerBI) describes How to turn on labels for stacked visuals with Power BI
- Sam Fischer highlights the Top 3 ways to direct attention with conditional formatting for column charts in Power BI
Deployment, Security and Operations
Covering: Workspaces and Apps, Template Apps, Deployment Pipelines, Gateways, Security, Sharing, Licences, Admin operations, Developer Tooling
- Philipp Lenz (@lenz_philipp) writes about Azure Runbooks and pausing Power BI A-SKUs
- On the Power BI blog, Anton Fritz (@AntonFritz15) highlights that the New export settings are available in the Power BI admin portal
- Also on the Power BI blog, Kay Unkroth discusses Moving on-premises AS and RS BI solutions to Azure – and closer to Power BI
- On the Prologika blog, Teo Lachev (@tlachev) writes about the Updated Export Settings and describes Understanding Power BI Endpoints
- Gilbert Quevauvilliers (@GilbertQue) describes How to enable dataset sizes larger than 10GB for Power BI Premium or Power BI Premium Per User
- Pat Mahoney (@HoosierBi) talks about Power BI - Tales From The Front - REST APIs
General
Covering: Cross-topic announcements & feature summaries, Whitepapers, Community events, Learning Resources & Certifications, Podcasts, Sample reports, End-to-end walkthroughs
- On the Burningsuit blog, Alison Box shares “Strictly Come Dancing” Telling the Story Behind the Numbers with Power BI
- Chris Webb (@cwebb_bi) shares the Session Recording: Advanced Analytics Features In Power BI
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 170 - Deeper Dive into recent Power BI news
- Erik Svensen (@donsvensen) talks about Spot the difference between Power BI Desktop and Power BI Desktop (Store Version)
- Matt Allington (@ExceleratorBI) describes Loading a File from OneDrive Personal into Power BI Desktop
- On the Towards Data Science blog, Nikola Ilic (@DataMozart) writes Power BI & Synapse Part 4—Serverless SQL: How much will it cost me?
- Ruth Pozuelo Martinez (@CurbalEN) explains how to Visualize La Liga Match results, the google way
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.