cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
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.

 

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.

 

Helpful resources

Announcements
Back to School Contest

Back to School Contest

Engage and empower students with Power BI!

MBAS Gallery

Watch Sessions On Demand!

Continue your learning in our online communities.

Summit Australia 2019

Summit Australia 2019

Travel to Melbourne and network with thousands of peers!

PBI Community Highlights

PBI Community Highlights

Check out what's new in the Power BI Community!

Top Ideas
Users Online
Currently online: 27 members 904 guests
Please welcome our newest community members: