Thanks for watching this week's Power BI news roundup! Last weeks roundup 2 Minute Tuesday Patrick's tech video Adam's tech video Sources SYNC SLICERS & SYNC SLICERS ADVANCED OPTIONS (@pkamasani) Definitive Guide to Implement On-premises Data Gateway (Enterprise Mode) in Organisations (@biinsightnz) Microsoft a Leader in Gartner’s Magic Quadrant for Analytics and BI Platforms for [...]
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup126a 2 Minute Tuesday: https://guyinacu.be/tenant Patrick's tech video: https://guyinacu.be/streamingdataset Adam's tech video: https://guyinacu.be/adddomain Sources Workspace V2 of Power BI: What Are Advantages Vs Old Version? (@Rad_Reza) How Many Data Gateways Does My Azure BI Architecture Need? (@mmarie) Bulk Operations in the Admin Portal [...]
In this video, Patrick introduces the Mashup Engine Query Monitor for Power BI Refresh. This is the MEQM! A report that can be useful to see SQL Server queries that Power BI issues during refresh. MEQM Files - https://github.com/guyinacube/demo-files/tree/master/video%20demos/MEQM
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 [...]
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 [...]
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, 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 [...]
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 [...]
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.
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 [...]