Forum Discussion
Impactful IndividualIssues with Automatic Update of eTracker Data in Power BI Service
Hi everyone,
I have set up a connection to eTracker in Power BI. Everything works fine in Power BI Desktop, but I am experiencing issues with the automatic refresh of the report in the Power BI Service. In the Service, I receive the following error:
Error refreshing data source credentials: The credentials provided for the Web source are invalid
In Power Query M, I am using the following web-url section:
https://ws.etracker.com/api/v7/ ...... rest_request", [Headers=[#"X-ET-Token"="187...
Could it be that Power BI Service does not support header-based authentication, which is required for the eTracker token? If so, it might not be possible to use these reports in the Service.
Has anyone had experience with connecting eTracker and setting up automatic refresh in Power BI Service?
Thanks in advance!
Best regards,
Pikachu-Power
Hi Pikachu-Power,
How is the connection set up in the service?
You should be able to create a new cloud conneciton with the type Web, select anonymous auth, and skip the connection test:
Then use that connection in your report, and then in PQ override the auth headers like you are doing.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
5 Replies
- tayloramy
Super User
Hi Pikachu-Power,
How is the connection set up in the service?
You should be able to create a new cloud conneciton with the type Web, select anonymous auth, and skip the connection test:
Then use that connection in your report, and then in PQ override the auth headers like you are doing.
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
- lbendlin
Can you successfully connect in Postman? If yes, what is the call type (POST or GET) and what are the headers?
Pikachu-PowerI tested the request using PowerShell (same as Postman) and received a StatusCode: 200 OK response, so the connection works correctly.
Call type: GET
Headers:
X-ET-Token: [my eTracker token]
So the API and token are working fine — the issue seems to be that Power BI Service doesn’t support header-based authentication for automatic refresh. Everything works normally in Power BI Desktop.
I’ve now set up a new cloud connection (anonymous, data protection no value, skip connection) instead of using the private cloud connection. It seems to be working, but I’m still testing. What was the reasoning behind this setup? Why is it working now?
- tayloramy
Glad it's working.
Most things in Fabric need to have an explicit connection to work (except for dataflow gen 2, those are weird...)
If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.
- Pikachu-Power
The update doesnt run very fast but it seems to work. Thanks 🙂
