Using Username() in DAX with Row-Level Security
The trick to getting, the DAX function, Username() to return the user’s User Principal Name (UPN) in Power BI, is that you have to configure Row-Level Security (RLS) on the dataset within the Power…
The trick to getting, the DAX function, Username() to return the user’s User Principal Name (UPN) in Power BI, is that you have to configure Row-Level Security (RLS) on the dataset within the Power…
I’ve been noticing a lot of discussion on the community site, in my emails, and in conversation from people having trouble connecting to Analysis Services through the Power BI Gateway – Enterprise. I thought it might help if I break down what actually happens, and what you need to configure to create a successful connection.
This post will look at two different approaches for expanding a record from a list using Power BI and a bit of M syntax. In our specific case, a customer wanted to pull data from a record that was listed in the table output of a SharePoint list.
You may be in a situation where you have disabled AllowAdHocSubscriptions for Azure Active Directory within your organization. This will prevent the ability for users to signup for Power BI. If your organization has this enabled, and no one has signed…
NOTE: This information is good as of 9/15/2015 and is subject to change! I get approached quite often regarding Azure Active Directory and how to get that working with Power BI. Here is an example of a question I received. I am investigating Power BI…