Power BI and Workfront Integration

[SMitch0505]

Does anyone have any experience connecting Power BI with Workfront via the API? I was able to get connected via web source with URL and token but when I try to use any of the fields in a visualization (see screenshot) or report it doesn't return any data. So I most likely did not configure the datasets correctly. Any assiatance or step by step help owuld be much appreciated.

[SMitch0505]

This is what I see in data view (only pulling 9 columns of data): 

And not seeing any errros in power query and as you can see here only pulling 9 columns of data

[MSRaymond]

How did you connect to the source in the first place? i have keys and login to workfront but i'm not clear how to connect... i've been using the "Get Data" nagivation but have had no luck.

[V-lianl-msft]

Hi @SMitch0505 ,

There are some third party services you can Buy for your purpose.

Alternatively you can Export your data to CSV or other format from WorkFront and then connect to the File from Power BI.

Best Regards,
Liang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[SMitch0505]

I believe I got the actual data connection figured out. I looked through the Workfront API explorer page and I wasn't using the correct object code. So I can connect succesfully to a bunch of their APIs but it's only returning about 8 columns where when I look in the API explorer there should be way more than that. Is there anything I might be doing that is restricting that? Link to API Explorer and screenshot of columns below. 

Workfront API Explorer   (object code I am working with is PROJ)

[MSRaymond]

@SMitch0505 did you ever figure out why only 8-9 rows were returned? I have gotten to this step and not sure what to do, thx

[amitchandak]

@SMitch0505 , I am hoping it is import mode, do you see any data in the table, check-in data view.

Can you please check in power query for any error