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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

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
July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

Find out what's new and trending in the Fabric Community.