Forum Discussion
Application with an API - connect to Power BI?
Hello,
I'm going to be really simplistic here, apologies in advance! I've previously worked with on-premise applications in my company where I've simply gone Get Data > SQL Server, chosen the relevant table(s) and it's smooth riding after that.
We've recently purchased a new SaaS solution whose data we wish to use in Power BI but that doesn't have an available connector. It does, however, have an open API. By that particular app having an API does it mean (-programmatically) we can hook it into Power BI? Do we need it be a specific type of API to do that? (Here's where my head hurts...!)
Many thanks
You can use “Get Data->Web” entry in Power BI Desktop or directly add connection information in Advanced Editor to connect to your API. There are some samples for your reference.
Analyzing Web page data using Power BI Desktop (tutorial)
Power BI – Connect to your secure API
API Strategies with Power BI
Regards,
Lydia
3 Replies
You can use “Get Data->Web” entry in Power BI Desktop or directly add connection information in Advanced Editor to connect to your API. There are some samples for your reference.
Analyzing Web page data using Power BI Desktop (tutorial)
Power BI – Connect to your secure API
API Strategies with Power BI
Regards,
LydiaI was able to connect to the API and refresh data in PowerBI desktop. I then Published the chart.
How do I refresh the data in PowerBI Service?
If I go to the Datasets tab, it says - your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again. What credentials is this looking for?
Thanks!
Were you ever able to figure out how to get the data to referesh in the service?
