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