how do I see all fields of a questionnaire on Power BI using ContentAPI

[ApoorvaIyengar]

@Anonymous  @JeffLetterman 

On PowerBI I don't see all fields when I make a call to /contentAPI/Control_Self_Assessments_1

For example, i am looking for a few value lists (Quarter, Overall Status) and I don't see any of those. How do I locate them? 

[Anonymous]

@ApoorvaIyengar,

Are you using account with enough access, like sysadmin?

[ApoorvaIyengar]

Yes, I am using sysadmin account. I was able to pull all of the fields using /$metadata on the API Testing tool, but it doesn't seem to be working that way on Power BI. Is there a config change that's needed? 

[Anonymous · Accepted solution]

If you are using the same url calls with both API Testing tool and Content BI, then there should not no difference.

[ApoorvaIyengar]

Thanks. I figured out that the value list fields were dependent on another table, so I was able to find them when I looked in 'Transform Data' tab.