Patrick looks at a few data modeling best practices in Power BI and Analysis Services. These are things we see customers doing on a regular basis and you should be aware of it.
Need a new search?
If you didn't find what you were looking for, try a new search!
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.
In this Power BI Tutorial, Patrick will show you how you can grow up a Power BI Desktop file (PBIX) to Analysis Services. He's all about learning the clicks! This is a Power BI tutorial worth watching! You can build your model within Power BI Desktop and then use Azure Analysis Services to migrate to [...]
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 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.
CREATE AN APP-LIKE EXPERIENCE IN POWER BI WITH BOOKMARKS (@BlueGraniteInc) When to Scale-Up or Scale-Out with Azure Analysis Services (@SQLbyoBI) ACCESS MICROSOFT GRAPH API USING POWER BI (@pkamasani) Fixing the Truncating Bar Chart (@powerbitips) Data Driven Subscriptions in Power BI (@angryanalytics) BONUS ITEMS: Reporting Services PowerShell Esri Plus Subscription for ArcGIS Maps for Power BI [...]
In this video, Patrick looks at the ragged hierarchy problem within Excel and Power BI when you are pulling data from Analysis Services. He looks at how you can correct the issue easily within Excel and some alternatives for Power BI.
In this video, Patrick looks at how you can provide access to your Azure Analysis Services server to external users. This is done by way of the Business to Business (B2B) capabilities of Azure Active Directory. He then takes it to the next level and shows how you can then take advantage of this within [...]
Using and optimizing DirectQuery in #powerbi and #ssas #tabular (@marcorus) The Must Have Resource list to Master Power BI (@theexcelclub) What’s new in SQL Server 2017 CTP 2.0 for Analysis Services How Microsoft uses Power BI to run its growing cloud business Connecting to datasets in the Power BI service from Desktop BONUS ITEMS: Over [...]
In this video, Patrick answers your question about how to do this in Analysis Services Tabular and Multidimensional. Also, he adds a little bit of SQL to the mix. Make sure to watch the previous dynamic filtering videos to understand the basics of how to do this. To begin, you need to make sure to [...]