Forum Discussion
Web API Data Source Credentials issue in service
Thank you for your prompt reply! aj1973
Hi acepuke
Here are a few steps you can try to resolve this issue:
1. Check the Data Source Settings in Power BI Desktop: Before publishing, go to ‘Home’> ‘Edit Queries’> ‘Data Source Settings'. Ensure that the credentials are set correctly here and that you're able to refresh the data successfully in Desktop.
2. Use the Correct Authentication Method: When setting up the data source credentials in the Power BI Service, you should use the 'OAuth2' authentication method for bearer tokens. Select 'OAuth2' and then enter the token in the access token field.
3. Verify the Token: Ensure that the bearer token you are using is still valid and has not expired. You may need to request a new token from the third-party service if it has expired.
4. Check Dataset Settings in Power BI Service: After publishing, go to the dataset settings in the Power BI Service. Under 'Data source credentials', set the authentication method to 'OAuth2' and paste your bearer token.
Best Regards,
Jayleny
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.