fbpx

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-30T10:05:07-05:00

Using Azure SQL Database Failover with Power BI

In this video, Patrick shows you how you can easily use Azure SQL Database Failover Groups with Power BI to ensure you have access to your data. Connecting to an Azure SQL Database Failover Group from Power BI is easier than connecting to a secondary replica of an Always On Availability Group.

Using Azure SQL Database Failover with Power BI2018-01-24T10:05:00-05: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-23T10:05:09-05:00

Icon map, Report Layouts and Power BI Developer update

Introducing Layouts (@powerbitips) Power BI - Icon Map custom visual - Analysing and animating flight data (@jamesdales) Mean Time Between Failure (MTBF) and Power BI (@GregDeckler) Balanced Scorecards in Power BI Power BI Developer community January update BONUS ITEMS: Installing SSRS 2017 (@BeginTry) Customizing Data Alerts in Power BI using PowerApps (@SQLJason) Analyzing Salary Data [...]

Icon map, Report Layouts and Power BI Developer update2018-01-18T11:05:24-05:00

Preventing Data Silos with Power BI

In this video, Patrick and Kalyn look at data silos and how to prevent it using Power BI. Different options exist, such as Analysis Services, Azure Analysis Services or models hosted in the Power BI service.

Preventing Data Silos with Power BI2018-01-18T10:39:20-05:00

Power Query and a new Power BI Desktop update

Power Query – Consecutive Days (@PowerPivotPro) The Each Keyword in Power Query (@kpuls) Remove repeating characters from a string in Power BI and Power Query (@TheBIccountant) "In the Previous" Date Filters In Power BI/Get&Transform/Power Query (@cwebb_bi) Query folding to improve Power BI performance (@CurbalEN) Power BI Desktop January Feature Summary BONUS ITEMS: Adding Comments & [...]

Power Query and a new Power BI Desktop update2018-01-11T13:38:50-05:00

Download and Deploy a K12 Power BI Solution for schools

In this video, Patrick shares a Power BI solution he created for K12 schools in United States education. This solution includes instructions to create views for use with the Power BI reports. It also includes a Power BI Desktop template for pre-created reports based on your school data.   GitHub Repo - https://github.com/pleblanc72/K12-PBI-Attend-and-Incidents

Download and Deploy a K12 Power BI Solution for schools2018-01-10T12:43:35-05: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-05:00

Fonts, Images, Power BI Contests and more…

Font Families in Power BI (@dataveld) Dynamic Attributes In A Power BI Report (@PowerPivotPro) Embedding Images in Power BI using Base64 (@SQLJason) Year in Review Contest: Jan. 3-Jan. 31 Happy New Year from Power BI Desktop BONUS ITEMS: EARLIER vs EARLIEST in DAX (@ExceleratorBI) Power BI Connections: Direct Query (@Eno1978) Regular Expressions will save your [...]

Fonts, Images, Power BI Contests and more…2018-01-04T11:03:12-05:00