Forum Discussion
OData feed permissions
Hello, i have created a report to pull from a web based app. I am using an OData feed as my source. This report is intended for another user and I'm having authentication issues when they try to refresh the data. There are four methods of authentication and im a little confused as to which route to go. It seems since i created the report the user cannot authenticate with their credentials. I tried anonymous access as well but received the error below. Given I need to create multiple reports for end users how should i work around this issue? thanks
- Anonymous5 years ago
You can pass ApiKeyName in the OData.feed() use Power Query. For more information, see:
authenticating with Excel Power Query against .Net Odata Web Api
API Strategies with Power BIPaul Zheng _ Community Support Team
2 Replies
- mahoneypatMicrosoft Employee
Does the API provider have a documentation page? That will show you the needed syntax and authentication approach. If you have an access token, you can just put that in the web call and use Anonymous authentication.
Pat
- AnonymousNot applicable
You can pass ApiKeyName in the OData.feed() use Power Query. For more information, see:
authenticating with Excel Power Query against .Net Odata Web Api
API Strategies with Power BIPaul Zheng _ Community Support Team