Free book, Updates for SSRS and SSAS and an updated Power BI gateway

Online Book: Analytics with Power BI and R (@leila_etaati) When to Use SUM() vs SUMX() (@ExceleratorBI) Model Comparison and Merging for Analysis Services SQL Server 2017 Reporting Services Release Candidate now available Power BI On-premises data gateway – July Update is now available! BONUS ITEMS: Value.Compare in Power BI, An Advanced Power BI Class Excerpt [...]

Adam and Patrick Unplugged – May 2017 [EP3]

In this episode of the Adam and Patrick Unplugged Show, we were at SQL Saturday NYC and thought we would bring in a few guests to join us and talk about what they are doing and what they could share with you! Jonathan Stewart (1:31) Twitter: @SQLLocks Website: https://sqllocks.com Where you can see Jonathan next: [...]

Using R Visuals with Power BI

You can take advantage of the R Script showcase to start using R Visuals with your reports. These provide great examples of what your R Script should look like to interact with data and you can compare how your visual looks to the example. R Script Showcase R Open (Script engine) Webinar: Getting started with [...]

Maps, stories and webinars – Roundup #60

This was a bit of a slow week, but we had a few interesting items. David Eldersveld talks about TopoJSON maps and Power BI. Marco Russo had some Q&A follow up to his #24HOP session. I also talked about the Data Stories Gallery and the Power BI Webinars. Lastly, we had some news about Power [...]

Excel, Mobile and geocoding – Roundup #54

In today's roundup I have a post about using Excel to work with Power BI data, creating phone layouts for dashboards, some geocoding, and something a little fun. ANALYSE POWER BI DATA IN EXCEL (@sobnz) Geocoding using R and Google Maps in Power BI (@AnkitPatira) Optimize your phone experience with a new customizable dashboard New [...]

Power BI Desktop, R visual and more – Roundup #52

This week we look at Power BI Desktop, KPIs and R visuals. Also, this is a special week because it is episode #52. That's one year of roundups! To celebrate and say THANK YOU, I'm giving something away! I will announce the winner in next weeks roundup! Dynamic Row Level Security with Power BI Made [...]