cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
niki_b
Frequent Visitor

Invalid Credentials in Power BI Service

Hi,

I am trying to refresh my data in Power BI service but it returms me an error saying invalid credentials.

 

niki_b_0-1620855229266.png

 

I am using my organizations's apis to get data in Power BI desktop. I have generated bearer token in the Advanced Editor itself and set up the credentials to anonymous in desktop app. 

 

 

I am trying to set the credentials to anonymous in service as well. But it is not working. My ultimate goal is to set up scheduled refresh for the data in service. How can I resolve this issue?

Thanks

1 ACCEPTED SOLUTION
ranbeermakin
Resolver III
Resolver III

@niki_b This will not work since the power query will try to query the root URL. You may use a gateway and skip test connection. Read more here: https://powerbi.microsoft.com/en-us/blog/skip-test-connection-for-on-premises-and-cloud-data-sources...

View solution in original post

2 REPLIES 2
ranbeermakin
Resolver III
Resolver III

@niki_b This will not work since the power query will try to query the root URL. You may use a gateway and skip test connection. Read more here: https://powerbi.microsoft.com/en-us/blog/skip-test-connection-for-on-premises-and-cloud-data-sources...

View solution in original post

Thanks. I kind of figured it out later.

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group!

MBAS on Demand

Microsoft Business Applications Summit sessions

On-demand access to all the great content presented by the product teams and community members! #MSBizAppsSummit #CommunityRocks

MBAS Attendee Badge

Claim Your Badge & Digital Swag!

Check out how to claim yours today!

Top Solution Authors