Dspace Reporting - REST API as data source for Power BI reporting

[Snickers]

Hi all,

I am working on setting up Power BI report using REST API as data source. I have had some success importing all data from /api/discover/objects to Power BI. I found useful info from:

https://wiki.lyrasis.org/display/DSDOC7x/REST+API

https://dspace-labs.github.io/DSpace7RestTutorial/

The challenging part is where I need authentication to access data e.g. /api/core/items

PowerBI provides quite a few authentication methods but not sure if any works with Dspace REST API:

Except "Anonymous" nothing seems to work. The only thing I am convinced that might work is the API Key option above but not sure how this can be done. Could I please get some help here?

Regards,

Bryan

[Snickers]

Also have an option as below:

But not sure how this may work with CSRF token requirement.