Power BI Weekly Issue 49: 10th March 2020
The first exciting announcement this week is that Export report to PDF, PPTX and PNG files using Power BI REST API functionality is now in preview. Although there are currently a few limitations, including the fact that the report and dataset must reside on a dedicated capacity (i.e. Premium or Embedded). Learn more about the limitations here. Elsewhere, there have been updates to the Power BI Mobile app - it's now possible to multi-select data on visuals, for example. Finally, in AAS land, there is Improved resource governance for Azure Analysis Services.
Elsewhere this week, Gilbert Quevauvilliers has showcased a Real implementation of Approximate Distinct Count vs DISTINCTCOUNT and has shown it to be 7X faster, Christian Widgren has asked Is Self-Service BI feasible for everyone?, and Bruno Bossaerts has been Benchmarking Off-The-Shelf Sentiment Analysis.
Data Prep
Covering: Power Query (M), Dataflows, Data connectors, Analysis Services
- Jason Cockington walks through Scraping data from JavaScript web sites with Power Query
- On the Towards Data Science blog, Christopher Tao writes about Power BI Connects to Azure Databricks
- On LaDataWeb, Ignacio Barrau (@ignacho_07) writes about Tipos de conexión [Spanish]
Data Modeling
Covering: Relationships, Calculated Columns, Calculated Measures, Calculated Tables, DAX
- On the SQLBI blog, Marco Russo (@marcorus) blogs about Currency conversion in Power BI reports
- Patrick Leblanc (@GuyInACube) talks about The How and Why of Power BI Aggregations
- Gilbert Quevauvilliers (@GilbertQue) writes that A Real implementation of Approximate Distinct Count vs DISTINCTCOUNT is 7X faster!
- On YouTube, Markus Ehrenmüller-Jensen (@MEhrenmueller) talks about Numeric calculations in Data Analysis Expressions with Power BI
- On the Prologika blog, Teo Lachev (@tlachev) talks about NullToZero in Power BI and Tabular
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) writes a number of blogs: Showing Month to Date MTD To Current Date In Power BI Using DAX, Advanced Analytics In Power BI: Threshold Triggers Using DAX, Master Virtual Tables in Power BI Using DAX, Using Moving Averages To Show Trends in Power BI, Showcase QoQ Sales Using Time Intelligence In Power BI and Showcasing And Understanding Anomalies In Power BI
Report Design and Visualizations
Covering: Report layout and formatting, Mobile reports, Native & Custom visuals, R & Python integration, Visual interactions, Report Themes
- David Eldersveld (@dataveld) writes about Extending Power BI Buttons Beyond the Default Icons
- On the Power BI Tips and Tricks blog, Seth Bauer (@Seth_C_Bauer) blogs about Keeping it Versatile
- On the Enterprise DNA blog, Sam McKay (@_EnterpriseDNA) describes How To Add Custom Icons Into Your Power BI Reports
Data Exploration
Covering: Dashboards, Quick Insights, Q&A, Filters, Bookmarks, Drill-through
- On the Towards Data Science blog, Bruno Bossaerts writes about Benchmarking Off-The-Shelf Sentiment Analysis
- Chandeep Chhabra (@chandeep2786) shares a Corona Virus Tracker Dashboard
- Paul Turley (@paul_turley) writes about Correlating Corona Virus Outbreaks with Business Data using the ESRI Map in Power BI
Deployment, Security and Operations
Covering: Apps and App Workspaces, Template Apps, Datasets, Gateways, Security, Sharing, Licences, REST APIs, PowerShell cmdlets, .NET SDK
- On the Power BI blog, Alon Baram writes about the Export report to PDF, PPTX and PNG files using Power BI REST API (Preview)
- Adam Saxton and Patrick Leblanc (@GuyInACube) present Let's Talk Power BI Gateways and Adam explains how to Get started with the Power BI Gateway
- On the Power BI community blog, Timo Riikonen (@TimoRii) blogs about Localization in Power BI
- Charles Sterling (@chass) describes Creating a send-smile-component for Power Apps using Power BI and Application Insights
- the Azure updates team writes about the Improved resource governance for Azure Analysis Services
General
Covering: Public service announcements, Cross-topic feature summaries, Power BI Overviews, Upcoming webinars/events, Power BI Certifications
- On the Power BI blog, Maya Shenhav discusses Power BI Mobile - you are in control
- Christian Widgren wonders Is Self-Service BI feasible for everyone?
- Adam Saxton (@GuyInACube) discusses the MS Teams Power BI Update and more... (Roundup | March 2, 2020)
- On the Power BI community blog, Imke Feldmann (@TheBIccountant) explains How to provide sample data in the Power BI Forum
- On the MSSQLTips site, Koen Verbeeck (@Ko_Ver) blogs about Power BI Dashboard vs Report vs Workbook
- On the BIFocal podcast, John White and Jason Himmelstein (@bifocalshow) present Episode 137 - Going Viral
- Patrick Leblanc (@GuyInACube) explains how to Integrate Power BI reports in Microsoft Teams
- Also on the Power BI blog, Sandy Rivas (@SandyRivas) highlights the ‘Better Together’ T-Shirt Design Contest
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.