Unable to Connect to Data Source in Power BI Template App

[Suraj_Ncircle]

I have created a Power BI Template App that works with a Web API as a data source. The Template app loads sample data successfully when opened. It also provides an option to "Connect your data", which prompts the user to load their own data in template.

Configuration Details:
Parameter: The app requires a token as a parameter.
Authentication Method: Anonymous.
Privacy Level: None.
Issue:
When I try to connect to the data source using the "Connect your data" option, I receive the following error:

This occurs even though the token parameter is correctly set and the data source connection works perfectly in Power BI Desktop.

Steps Taken:
Verified the API endpoint with tools like Postman, and it responds correctly with the provided token.
Ensured the same token parameter works without issues in Power BI Desktop.
Tested different privacy levels and authentication methods, but the issue persists.

Questions:
1. What could cause this issue when the connection works in Power BI Desktop but fails in Power BI Service?
2. Are there specific considerations for Anonymous authentication and token-based API calls in Power BI Template Apps?
3. Is there any additional configuration required in the template app settings to handle this scenario?
I would appreciate any guidance or suggestions to resolve this issue. Let me know if more details are required.

[v-jianpeng-msft]

Hi, @Suraj_Ncircle 

I wish you all the best. Previously we have provided a solution to help you solve the problem. Since we haven't heard back from you yet, I'd like to confirm if you've successfully resolved this issue or if you need further help?
If yes, you are welcome to share your workaround and mark it as a solution so that other users can benefit as well. If you find a reply particularly helpful to you, you can also mark it as a solution.
If you still have any questions or need more support, please feel free to let us know. We are more than happy to continue to help you.
Thank you for your patience and look forward to hearing from you.

Best Regards

Jianpeng Li

[v-jianpeng-msft]

Hi, @Suraj_Ncircle 

I think you can refer to the following discussion:

Solved: How to pull data from Web API into PowerBI using A... - Microsoft Fabric Community

Solved: HOW-TO REST API calls + M + refresh in Power BI Se... - Microsoft Fabric Community

They will guide you if you use your token correctly in Power BI Service.

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.