cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
gabrielbur Frequent Visitor
Frequent Visitor

call a web api to retrieve machine learning results and create a report in power bi

Hi I am new in power Bi. I have a web service which is the result of my Machine Learning Azure training. I would like to show a report in my dashboard with the result of calling this web service. I cannot find the way to create a datasource with the api rest call. Any ideas?

thanks

 

1 ACCEPTED SOLUTION

Accepted Solutions
gabrielbur Frequent Visitor
Frequent Visitor

Re: call a web api to retrieve machine learning results and create a report in power bi

Thanks, I get to my goal doing something similar of what you've proposed. I have created a Data Factory in ML, which triggers a scheduled pipeline. This data factory, calls the web service ML which saves the result in SQL Azure DB. Then Power Bi is connected to SQL Azure DB and takes the last prediction.

 

View solution in original post

6 REPLIES 6
dramus Established Member
Established Member

Re: call a web api to retrieve machine learning results and create a report in power bi

Power  BI Desktop has the ability to connect to a web service.

 

Get Data -> Other -> Web

KHorseman Super Contributor
Super Contributor

Re: call a web api to retrieve machine learning results and create a report in power bi

The general web connector is not correct for this instance. You want to use the Azure Marketplace connector.

 

https://blog.crossjoin.co.uk/2014/10/19/sentiment-analysis-in-excel-with-azure-machine-learning-and-...


Did I answer your question? Please mark it as a solution.

Proud to be a Datanaut!
gabrielbur Frequent Visitor
Frequent Visitor

Re: call a web api to retrieve machine learning results and create a report in power bi

I could succesfully create on Power BI Desktop, but it is not updated on my power bi web. It mantains the value it had when I published the report. I would like to update the values on power bi web site, and to connect to the web service to update the value.

 

 

Re: call a web api to retrieve machine learning results and create a report in power bi

@gabrielbur

 

There seems no way to modify the connection string in powerbi service, you can vote it up.

https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/8786290-ability-to-change-the-dat...

 

wonga Established Member
Established Member

Re: call a web api to retrieve machine learning results and create a report in power bi

@gabrielbur

 

Maybe try the information from this Power BI Blog article: https://powerbi.microsoft.com/en-us/blog/power-bi-azure-ml/

gabrielbur Frequent Visitor
Frequent Visitor

Re: call a web api to retrieve machine learning results and create a report in power bi

Thanks, I get to my goal doing something similar of what you've proposed. I have created a Data Factory in ML, which triggers a scheduled pipeline. This data factory, calls the web service ML which saves the result in SQL Azure DB. Then Power Bi is connected to SQL Azure DB and takes the last prediction.

 

View solution in original post

Helpful resources

Announcements
Can You Solve These Challenge

Challenge: Can You Solve These?

Find out how to participate in the first Power BI 'Can You Solve These?' challenge.

Community News & Announcements

Community News & Announcements

Get your latest community news and announcements.

Virtual Launch Event

Microsoft Business Applications October Virtual Launch Event

Join us for an in-depth look at the new innovations across Dynamics 365 and the Microsoft Power Platform.

Community Kudopalooza

Win Power BI Swag with Community Kudopalooza!

Each week, complete activities and be qualified in the drawing for cool Power BI Swag.

Users Online
Currently online: 306 members 3,499 guests
Please welcome our newest community members: