topic Re: Power BI API in Developer

Power BI API

kkuhle — Thu, 04 May 2017 21:55:56 GMT

What is the best way to connect to our UltiPro cloud service - Power BI REST API or Get Data > Web?

Get Data > Web

If I type the web service I'm able to see Attribute:name and Attribute:targetNamespace and not the fields I need.

Power BI REST API

I followed the instructions from Adam Saxton Push data into a Power BI dataset but having issues pulling in multiple web services from our UltiPro provider.

Process

- Get authentication access token

- Create dataset in Power BI

- Get the dataset to add rows into a Power BI table

- Authenticate with UltiPro web service

- Query web service

- Add rows to Power BI table

Re: Power BI API

Eric_Zhang — Sun, 07 May 2017 09:24:01 GMT

@kkuhle wrote:

What is the best way to connect to our UltiPro cloud service - Power BI REST API or Get Data > Web?

Get Data > Web

If I type the web service I'm able to see Attribute:name and Attribute:targetNamespace and not the fields I need.

Power BI REST API

I followed the instructions from Adam Saxton Push data into a Power BI dataset but having issues pulling in multiple web services from our UltiPro provider.

Process

- Get authentication access token

- Create dataset in Power BI

- Get the dataset to add rows into a Power BI table

- Authenticate with UltiPro web service

- Query web service

- Add rows to Power BI table

@kkuhle

Both way should be good.

For the first approach, the data imported depends on the web link you pass. You shall figure out what are the UltiPro links/API shall be called to get expected data.

For the second approach, not clear about your "UltiPro provider", but it is definitely doable, eg in a C# console application.

Re: Power BI API

surfersamu — Wed, 30 Aug 2017 15:55:01 GMT

Were you succesful with this?

Re: Power BI API

kkuhle — Wed, 30 Aug 2017 16:02:00 GMT

No, I was able to create a program with the authentication access tokens to query data from UltiPro, but was never able to create the dataset that Power BI would access.

Re: Power BI API

surfersamu — Wed, 30 Aug 2017 16:06:41 GMT

Oh I see. Did you use C#? I'm tyring to do the exact same thing. I thought using a link with http Authorization headers would work but nothing.

The program you created can only query data form UtilPro but is not able to transfer anything to PowerBI?