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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

Reply
amaaiia
Continued Contributor
Continued Contributor

GetToken: Failed to get token authenticator for auth type: ServicePrincipal

Hi.

I have some Data Pipelines with a Semantic Model refresh activity, authenticating with Service Principal. One day, it stopped working, and it shows the following error since then:

amaaiia_0-1727780594748.png

 

I've created a new Data Pipeline with just Semantic Model refresh activity, I've configured it and still the same error. If I authenticate with my organizational account, it works, but I need to authenticate by Service Principal.

 

The PowerBIDatatsets connection that I'm using is correct, I've checked it in connections list. What does this error mean?

1 ACCEPTED SOLUTION
v-kongfanf-msft
Community Support
Community Support

Hi @amaaiia ,

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.


The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best Regards,

Adamk Kong

View solution in original post

6 REPLIES 6
v-kongfanf-msft
Community Support
Community Support

Hi @amaaiia ,

 

We have seen on the internal platform that other engineers have reported this issue and submitted it.


The engineers on the product team are now aware and will do their best to resolve the issue. I will update here if there is any progress, so please be patient.

 

Best Regards,

Adamk Kong

v-kongfanf-msft
Community Support
Community Support

Hi @amaaiia ,

 

Check the logs for any other error messages or detailed information that may help provide more insight into the problem.
Also check if a similar solution as below works for you.

azure - Authentication not granted for service principal token in MS Fabric API using Python - Stack...

 

Best Regards,
Adamk Kong

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Where can I get more logs? The pipeline is as simple as this: 

amaaiia_0-1727856734976.png

The activity is configured as follows:

amaaiia_1-1727856831008.png

And the connection: 

amaaiia_2-1727857000527.png

Notice the connection is ok, because if I manually change the key to a no valid key (just to test), I get this error:

 

amaaiia_3-1727857062315.png

So yes, the client id and key are VALID.

NandanHegde
Super User
Super User

can you confirm whether the client secret is still valid for the client ID? Meaning it has not expired




----------------------------------------------------------------------------------------------
Nandan Hegde (MSFT Data MVP)
LinkedIn Profile : www.linkedin.com/in/nandan-hegde-4a195a66
GitHUB Profile : https://github.com/NandanHegde15
Twitter Profile : @nandan_hegde15
MSFT MVP Profile : https://mvp.microsoft.com/en-US/MVP/profile/8977819f-95fb-ed11-8f6d-000d3a560942
Topmate : https://topmate.io/nandan_hegde
Blog :https://datasharkx.wordpress.com

I have the exact same problem with a Service Principal that has been created just now:

GEIV_0-1727873346440.png

Service Principal has been granted Contributor access in the Azure Data Factory I am trying to connect to.

amaaiia
Continued Contributor
Continued Contributor

Hi,

I know is valid because of two reasons:

1. When I create a new connection using these keys I don't have any errors. For example, If I change a character in the secret, it returns an error message that is not valid.

2. I have another SQL Server connection created to access data in a Lakehouse as data connection for semantic model, using service principal authentication, and it works.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.