Power BI API

[kkuhle]

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

[surfersamu]

Were you succesful with this?

[kkuhle]

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.

[surfersamu]

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? 

[Eric_Zhang]

---

@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.