Forum Discussion
Impactful IndividualIssues with Automatic Update of eTracker Data in Power BI Service
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.
Super UserCan you successfully connect in Postman? If yes, what is the call type (POST or GET) and what are the headers?
Impactful IndividualI 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.