Azure Analysis Services, Power BI, and the On-Premises Data Gateway

In this video, Patrick looks at when you need the On-Premises Data Gateway when using Azure Analysis Services (Azure AS). Do we need it with Power BI? Or just Azure AS? What's the difference? Patrick also shows you why your gateway may not show up in the Microsoft Azure portal.

M Intellisense, Bookmarks and more

The Man, The Myth, The On-Prem Server Guy… (@PowerPivotPro) M QUERY EXTENSION FOR VISUAL STUDIO CODE (@BrettPowell76) Walk Through Of Many Ranking Techniques using DAX in Power BI (@Enterprise_DNA) Power BI Desktop October Feature Summary Power BI Service and Mobile September Feature Summary BONUS ITEMS: Offline model editor experience for Power BI (@marcorus) Data types [...]

Languages and timelines in Power BI and previews

Hurricane Harvey Donations: American Red Cross Salvation Army Humane Society Hurricane Harvey Relief Fund Roundup Items: Context Transition in DAX/Power BI: A Visual Guide (@csgpro) Multilanguage Multilingual reports in Power BI (@CurbalEN) Introducing per-user usage metrics: know your audience and amplify your impact Create interactive timeline visualizations for your data with the new timeline storyteller community [...]

Give external users access to your Azure Analysis Services server

In this video, Patrick looks at how you can provide access to your Azure Analysis Services server to external users. This is done by way of the Business to Business (B2B) capabilities of Azure Active Directory. He then takes it to the next level and shows how you can then take advantage of this within [...]

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 [...]

Guy in a Cube hanging out with Andy Leonard from DataDriven.TV

Patrick and Adam were at SQL Saturday Atlanta. While there, they caught up with Andy Leonard from DataDriven.TV and participated in one of their podcasts. They did a Facebook live stream and posted this on their podcast channel. Adam had his camera equipment and also grabbed it. Here is the Guy in a Cube video [...]

Power BI Report Server, data privacy and more

Data Privacy Settings In Power BI/Power Query, Part 1: Performance Implications (@technitrain) SSAS TABULAR VS MULTIDIMENSIONAL FEATURE MATRIX (@BrettPowell76) Reusing Datasets Imported to the Power BI Service (@SQLChick) Power BI Report Server preview now available What’s new in SQL Server 2017 CTP 2.1 for Analysis Services BONUS ITEMS: How to compute index numbers at top [...]