Power BI and the On-premises Data Gateway: What is it?

In this video, we look at the On-Premises Data Gateway. What is it exactly? This can be used with more than just Power BI. This includes PowerApps, Microsoft Flow, Azure Analysis Services and more. The entire Power Platform! If you found this video helpful, we have a free cheat sheet for you for more details [...]

Power BI and the On-premises Data Gateway: What is it?2018-09-08T10:17:20+00:00

Power BI colors, data models, release notes and more… (June 4, 2018)

Choosing a Color Palette For Your Power BI Report (@mmarie) DATA MODEL ANTI-PATTERNS (@BrettPowell76) On-premises data gateway May update is now available Power BI Developer community May update Business Applications Release Notes - Spring '18 Release BONUS ITEMS: A Few More Power BI Roadmap Details From The Dynamics 365 Release Notes (@cwebb_bi) Time Dimension in [...]

Power BI colors, data models, release notes and more… (June 4, 2018)2018-06-04T06:39:24+00:00

Power BI, Azure Analysis Services, and the gateway data region

In this video, Adam looks at data regions and how they work with Power BI, Azure Analysis Services, and the On-Premises Data Gateway. For the use of a single gateway, all services must be within the same data region. Using a second gateway might be your only option to get things to work.

Power BI, Azure Analysis Services, and the gateway data region2018-01-23T20:31:07+00:00

Power BI User lookup with the gateway using Active Directory

In this video, Adam looks at how you can use Active Directory custom attributes for the user lookup with the Power BI Gateway. This can be used for both Analysis Services mapping and the Kerberos SSO with DirectQuery connections. Manage your data source - Analysis Services Creating Custom Active Directory Attributes Adding Custom Attributes in [...]

Power BI User lookup with the gateway using Active Directory2018-01-21T21:20:44+00:00

The On-Premises Data Gateway and Power BI – Revisited

In this video, Adam revisits the On-Premises Data Gateway to help get you up and running with it. This was looked at a year and a half ago and things have changed. The On-Premises Data Gateway can be used with Power BI along with other services like Azure Analysis Services, Microsoft Flow, and PowerApps. Install [...]

The On-Premises Data Gateway and Power BI – Revisited2018-01-10T12:38:53+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

Power BI & SQL Server Always On Availability Groups

In this video, Patrick shows how you can successfully connect to your SQL Server Always On Availability Group (AG) Secondary Read Replica using Power BI Desktop and the On-Premises Data Gateway. Adam jumps in to show you what the connection string looks like when you use this approach. Configure Read-Only Routing for an Availability Group [...]

Power BI & SQL Server Always On Availability Groups2017-09-07T10:48:21+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

Dynamic Power BI reports using Parameters

In this video, Patrick shows you how you can use a parameter, within a Power BI report, to dynamically change the data in a report. This uses M Functions within Power Query and a second source that has the key values to pull. Then using a gateway to enable refresh.

Dynamic Power BI reports using Parameters2017-05-24T10:03:36+00:00

Adam & Patrick Unplugged – EP1

In this video, Patrick and I talk about what is on our minds. We take a look at some custom visuals within Power BI and also talk about the On-Premises Data Gateway. What is Adam and Patrick Unplugged? 0:24 Custom Visuals on Office Store - 6:22 Play Axis Custom Visual - 10:43 Gateway updates - [...]

Adam & Patrick Unplugged – EP12017-03-31T09:03:23+00:00