Adam walks through how to setup a live connection to Analysis Services, or Azure Analysis Services, in Power BI Desktop. This also involves getting things working with the On-Premises Data Gateway.
Thanks for watching this week's Power BI news roundup! Last weeks roundup: https://guyinacu.be/roundup135 2 Minute Tuesday: https://guyinacu.be/reportbackground Patrick's tech video: https://guyinacu.be/slicerperf Adam's tech video: https://guyinacu.be/nextlevelbutton Sources Creating a Table Heatmap in Power BI (@HavensBI) Using The “Skip Test Connection” Option For Power BI Data Sources To Avoid Scheduled Refresh Failures (@cwebb_bi) Announcing Query Caching in [...]
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 [...]