Forum Discussion
Connecting an API to PowerBI
Hello,
I am unable to connect an API weblink that is a table of data to PowerBI, however I could connect the API to Excel.
Furthermore, someone at a different organisation could successfully connect the API in PowerBI with anonymous credentials. This indicates there must be an Admin setting in PowerBI that needs to be changed at my organisation. What settings do I need to connect the API?
Any help or guidance about how to resolve this will be greatly appreciated.
3 Replies
Anonymous , Are you looking for REST API connection?
Rest API
https://community.powerbi.com/t5/Power-Query/Using-a-REST-API-as-a-data-source/td-p/50400
https://www.progress.com/tutorials/odbc/directquery-your-custom-rest-api-in-power-bi
https://zappysys.com/blog/howto-import-json-rest-api-power-bi/
https://www.youtube.com/watch?v=ipI6mrWLQKAIt is not a REST API. On my work laptop it comes up with a DataSource.Error and I can't reach the PowerQuery.
I tried the API weblink on my home laptop, didn't have to change any settings, just logged in with anonymous credentials, and that successfully worked.
So, might there be a setting in the Admin Portal at my organisation which prevents this API from working in PowerBI?
Hi Anonymous
What data source are you using? Is it an Excel file on SharePoint? Please describe the problem in more detail.
Best Regards
Caiyun Zheng
Is that the answer you're looking for? If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
