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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Eric7
Resolver I
Resolver I

Dataflow via on-prem Oracle gateway: "Access token has expired, resubmit with a new access token"

From time to time, dataflows and datasets that have queries against datasources located on our on-prem Oracle gateway and queries against datasources located in dataflows in Power BI Service are failing with the error "Access token has expired, resubmit with a new access token". It appears (at least sometimes) to coincide with the forced re-authentication against our company domain, which happens at uneven intervals. What I have to do when this happens is to go into this page https://app.powerbi.com/groups/me/gateways , then go into Settings on this dataflow

Eric7_0-1714379899792.png

then click "Edit credentials" and reauthenticate.

 

Is there any way to prevent the token from expiring or set a longer expiration somewhere? Some setup on the gateway? It has been like this for several years, and the on-prem gateway is up to date.

 

1 REPLY 1
lbendlin
Super User
Super User

Not really.  

the forced re-authentication against our company domain, which happens at uneven intervals.

is your limiting factor, in addition to the token expiry imposed by Azure.  You can look into service principals but they may not help in your scenario.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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

Top Solution Authors