Debug DAX using Variables in Power BI

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

Debug DAX using Variables in Power BI2018-05-21T21:03:45+00:00

Power BI Tutorial – Grow up Power BI Desktop to Analysis Services (Learning the clicks)

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

Power BI Tutorial – Grow up Power BI Desktop to Analysis Services (Learning the clicks)2018-04-18T11:32:54+00:00

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.

Azure Analysis Services, Power BI, and the On-Premises Data Gateway2017-12-20T20:32:08+00:00

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

M Intellisense, Bookmarks and more2017-10-12T09:15:18+00:00

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

Languages and timelines in Power BI and previews2017-08-31T09:47:31+00:00

Ragged Hierarchies in Analysis Services with Power BI and Excel

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.

Ragged Hierarchies in Analysis Services with Power BI and Excel2017-08-23T01:26:53+00:00

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

Give external users access to your Azure Analysis Services server2017-07-26T07:04:16+00:00

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

Free book, Updates for SSRS and SSAS and an updated Power BI gateway2017-07-20T09:46:37+00:00

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

Guy in a Cube hanging out with Andy Leonard from DataDriven.TV2017-07-18T11:19:10+00:00

Let’s talk about Power BI Premium – Adam and Patrick Unplugged [EP4]

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

Let’s talk about Power BI Premium – Adam and Patrick Unplugged [EP4]2017-06-30T10:59:15+00:00