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 looks at how you can create mail-enabled security groups via PowerShell and copy members from an Office 365 Unified group into that new group. This came about based on a limitation that within Power BI, you can't list O365 Unified groups (what back App workspaces) from the people picker for access [...]
In this video, Adam and Patrick discuss their travels, including PASS Summit 2017. They also discuss the new Azure AD B2B support for Power BI. They sit down with Marco Russo to discuss a little DAX and catch up on things. Travels: 0:07 PASS Highlight: 3:23 News about Adam: 9:58 Azure AD B2B with Power [...]
In this video, Adam looks at how to manage the Power BI Premium capacity that you have purchased. He looks at what Global Admins can see, how you can assign capacity admins and users with workspace assignment, along with how to assign workspaces to a Power BI Premium capacity.
In this video, Adam walks through how to purchase Power BI Premium for your organization. This is done within the Office 365 Admin Center and you have to be a Global Admin or a Billing Admin to make the purchase. Adam talks about what a capacity node is along with how to get additional capacity [...]
In this video, I look at what Power BI Premium is and why you should care about it. I explain how to use it and the benefits you get from it. I also talk about what it is not by comparing it to Power BI Free and Power BI Pro licenses. What is Power BI [...]
In this video, I talk about the Power BI Admin Role! I look at how to assign it to a user and what you get, and don't get, with this role. Official Documentation Download Azure Active Directory PowerShell Version 2 Download Azure Active Directory PowerShell Version 1.1.166.0 GA
Two Great New Power BI Features (@ExceleratorBI) Get your own Power Query Editor using Notepad++ (@SchreiberLars) Power BI Gateways–March Update Announcing granular tenant settings in Power BI Power BI Desktop March Feature Summary Power BI Color Theme Generator BONUS: Implementing Header-Details in Power BI (@tlachev) Power BI – Infographic for Power BI from an end [...]
In this video, I answer a question I get fairly often. Can I use the audit log if I have the Power BI service administrator role assigned to me within Office 365. I also make an announcement about the future of Guy in a Cube. Admin portal doc Audit log doc Power BI Auditing for [...]
In this video, I look at how you can find Power BI users that have signed in within your organization. I start with looking at PowerShell to see which users have a license assigned, but then we can head over to Azure Active Directory and look at some of the reports that are built in [...]