Power BI Weekly
Issue #46 - 18th February 2020
I want to start by congratulating the Power BI team on the result of the Gartner 2020 Magic Quadrant for Analytics and BI Platforms, where Microsoft has been classed as a "Leader", with the strongest position on the chart. Well done!
Announcements this week: we've been told that E-Mail Subscription support for external e-mail addresses is coming soon in Paginated Reports, we've been given the On-premises data gateway February 2020 update, and finally, in Power BI Embedded, we've been told that the Power BI report authoring APIs now support a new aggregation function.
Elsewhere, Semjon Terehhov has described how to Read API Data with Power BI using Power Query, Chris Hamill has described Matrixed Report Navigation, and James Broome has written about Azure Analysis Services: How to open a connection from .NET.
🛠️ Data Prep
- On the MSSQLTips site, Semjon Terehhov explains how to Read API Data with Power BI using Power Query
- On the Power BI Tips and Tricks blog, Steve Campbell discusses some Power Query API Considerations
- On the Blue Granite blog, Olya Musokhranova (@OlyaMusok) walks through Monitoring Power BI On-Premises Data Gateway Performance
- Chandeep Chhabra (@chandeep2786) explains how to Replace Error Values in Multiple Columns
- Paul Turley (@paul_turley) discusses Power BI Query Performance & Query Diagnostics
🧩 Data Modeling
- Phil Seamark (@PhilSeamark) writes about a Dynamic Axis
- On the Power BI community blog, JarroVGIT blogs about Breaking Ties in Rankings with RANKX Using Multiple Columns
- Parv Chana (@parvchana) writes about Dynamic title/measure based on what is NOT chosen in a Power BI Slicer
- The Azure updates team discusses Power BI report authoring APIs now support a new aggregation function (Power BI Embedded)
- On the endjin blog, James Broome writes about a Azure Analysis Services: How to open a connection from .NET
⚙️ Report Design and Visualizations
- Chris Webb (@cwebb_bi) explains how to Make Your Power BI Report Run Faster By Showing The Same Data In Fewer Visuals
- On the Visual BI blog, Bhupinder Singh writes about 10 New feature in Gantt Chart Custom Visuals for Microsoft Power BI
- On the xViz blog, Ramkumar Sharma explains how to Visualize Corona Virus Outbreak using xViz Custom Visuals
- Chris Hamill (@ChrisHamill17) describes a Matrixed Report Navigation
- On the Power BI community blog, artemus describes how to Include Custom Icons in Your Tables
⚙️ Data Exploration
- On the Power BI community blog, Sam McKay (@_EnterpriseDNA) blogs about Inventory Management and Analysis Using Power BI
- Marc Lelijveld (@MarcLelijveld) talks about Synonyms, the secret behind Power BI Q&A and Natural Language Query
- Patrick Leblanc (@GuyInACube) describes how to Sort by more than one column in Power BI and provides a Cross Report SOLUTION for Power BI Report Server
- On the Power BI Tips and Tricks blog, Mike Carlo (@PowerBITips) writes Mind Blown
- On the Prologika blog, Teo Lachev (@tlachev) writes about a Power BI Report Slide Show and writes about Power BI Report Books
- On the xViz blog, Bhupinder Singh writes about 7 New Features in xViz Hierarchical Filter for Microsoft Power BI
- James Serra (@JamesSerra) talks about Power BI Real-time Streaming
🚀 Deployment, Security and Operations
- On the Power BI blog, Christopher Finlan (@cmfinlan) provides a Heads up: E-Mail Subscription support for external e-mail addresses is coming soon
- Also on the Power BI blog, Arthi Ramasubramanian Iyer (@ArthiRamasubra1) highlights that On-premises data gateway February 2020 update is now available
- Adam Saxton (@GuyInACube) writes about 6 things to get a little more out of your Power BI Desktop machine
- Gilbert Quevauvilliers (@GilbertQue) explains How you can store All your Power BI Audit Logs easily and indefinitely in Azure
- Kasper de Jonge (@kjonge) explains how to Get the SQL Query used in DirectQuery mode
🌐 General
- On the Power BI blog, Arun Ulag (@arunulag) highlights that Microsoft named a Leader in Gartner’s 2020 Magic Quadrant for Analytics and BI Platforms
- Also on the Power BI blog, Sandy Rivas (@SandyRivas) highlights the Exclusive LIVE Community Event #3 – Ask Arun Anything
- On the Power BI blog, Sandy Rivas (@SandyRivas) tells us to Meet the 2020 Season 1 Power BI Super Users
- Adam Saxton (@GuyInACube) discusses Lots of Power BI tips... (Roundup | February 10, 2020)
- Mark Walter (@markwalter_bi) writes about Finding Value In Data And Dialogue
- On the CSG Pro blog, Matthew Mitchell discusses Driving Organizational Change with Power BI