Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
test
Frequent Visitor

Publish report on power BI

I have published my report and I got the following error 

 

powerbi.png

 

I follow the following tuto 

 

https://powerbi.microsoft.com/en-us/blog/how-authentication-with-analysis-services-live-connections-...

 

I didn't find The Active Directory UserPrincipalName (UPN) , I am working on local machine and not on server , where to find it ?

2 ACCEPTED SOLUTIONS
KGrice
Memorable Member
Memorable Member

I suppose that makes sense after I re-read your original post 🙂 If you're only running local without a domain, you wouldn't be a domain user.

 

From the tutorial: "The email address that is passed into EffectiveUserName has to match a UPN property on a local Active Directory account. For this reason, the Analysis Services machine has to be joined to a domain. The domain of the email address has to match a UPN Suffix within your local Active Directory."

 

It looks like you need a domain account to do this. I don't know enough about it to help with a work-around if there is one. Hopefully someone else here will, or you could try contacting the author of the post for his take on it.

View solution in original post

Hi test,

 

Is your machine domain joined? And how did you configure the On-premises data gateway?

Active Directory UserPrincipalName (UPN) is a property of Domain User account Stored in Active Directory, and a local account of Windows system (if the machine didn’t join a domain) doesn’t have this.

If you use local machine to host the Databse server, there would be no logon server available to verify the authentication, when the data sources be configured to the local machine (not domain joined). Windows local accounts are only authenticated on the local machine(which only the local machine have the right to authenticate the account), while domain user accounts could be authenticated through Internet, or the network (bounded with Azure Active Directory). So Analytics Service Live connection is not available under personal local computer.

 

To have the Analytics Service live connection available under Power BI service, you need:

  1. A domain environment;
  2. On-premises data gateway;
  3. Bounded with AAD;

You may also take a look at the blog below for the detailed explanation:

Connecting to Analysis Services in Power BI

Regards

View solution in original post

4 REPLIES 4
KGrice
Memorable Member
Memorable Member

To find your Active Directory UPN, you can open the command line and run whoami/upn. Click the Windows button, type cmd into the search bar and hit Enter. Then type whoami/upn into the command line and hit Enter to return your UPN.

test
Frequent Visitor

Thanks for your answer.

 

I get the following error 

 

powerbi.png

Hi test,

 

Is your machine domain joined? And how did you configure the On-premises data gateway?

Active Directory UserPrincipalName (UPN) is a property of Domain User account Stored in Active Directory, and a local account of Windows system (if the machine didn’t join a domain) doesn’t have this.

If you use local machine to host the Databse server, there would be no logon server available to verify the authentication, when the data sources be configured to the local machine (not domain joined). Windows local accounts are only authenticated on the local machine(which only the local machine have the right to authenticate the account), while domain user accounts could be authenticated through Internet, or the network (bounded with Azure Active Directory). So Analytics Service Live connection is not available under personal local computer.

 

To have the Analytics Service live connection available under Power BI service, you need:

  1. A domain environment;
  2. On-premises data gateway;
  3. Bounded with AAD;

You may also take a look at the blog below for the detailed explanation:

Connecting to Analysis Services in Power BI

Regards

KGrice
Memorable Member
Memorable Member

I suppose that makes sense after I re-read your original post 🙂 If you're only running local without a domain, you wouldn't be a domain user.

 

From the tutorial: "The email address that is passed into EffectiveUserName has to match a UPN property on a local Active Directory account. For this reason, the Analysis Services machine has to be joined to a domain. The domain of the email address has to match a UPN Suffix within your local Active Directory."

 

It looks like you need a domain account to do this. I don't know enough about it to help with a work-around if there is one. Hopefully someone else here will, or you could try contacting the author of the post for his take on it.

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

Check out the February 2024 Power BI update to learn about new features.

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.