In this video, Marco Russo, from SQL BI, joins Patrick to look at how you can debug DAX using variables in Power BI. Marco helps to break down a DAX measure and show how you can see the results as you build it up to find where the problem is. SQL BI DAX Formatter DAX [...]
In this Power BI Tutorial, Patrick will show you how you can grow up a Power BI Desktop file (PBIX) to Analysis Services. He's all about learning the clicks! This is a Power BI tutorial worth watching! You can build your model within Power BI Desktop and then use Azure Analysis Services to migrate to [...]
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.
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 [...]
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 [...]
In this video, Patrick looks at the ragged hierarchy problem within Excel and Power BI when you are pulling data from Analysis Services. He looks at how you can correct the issue easily within Excel and some alternatives for Power BI.
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 [...]
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 [...]
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 [...]
In this episode of the Adam and Patrick Unplugged show, we talk about some travel updates, ragged hierarchies and a lot about Power BI Premium. Travel Update - 0:39 Ragged hierarchies - 2:15 Power BI Premium - 8:12 Travel stories - 33:27