Forum Discussion

michaelshparber's avatar
michaelshparber
Advocate V
6 years ago
Solved

Scheduling Custom Function that calls for API with Bearer Authorization - possible in the service?

Hello,

I have to API calls with Bearer Token Authorization

The first returns a list of users

The second takes a user as a parameter and makes another API call to get some data for that user.

I have created a Custom Function and add a column that calls for this function for each user.

Works great in the desktop but cannot make it work in the Service.

Is it possible? How can I make it refresh (I need to do it with Bearer Token)

Thanks

Need Help

4 Replies

    • michaelshparber's avatar
      michaelshparber
      Advocate V
      6 years ago

      v-lionel-msft 

      Thanks for the direction.

      Now it allows me to enter credentials but I am getting a different error when refreshing:

      Please help

      Thanks!

      Data source error:{"error":{"code":"ModelRefresh_ShortMessage_ProcessingError","pbi.error":{"code":"ModelRefresh_ShortMessage_ProcessingError","parameters":{},"details":[{"code":"Message","detail":{"type":1,"value":"[Unable to combine data] Section1/users (2)/AutoRemovedColumns1 references other queries or steps, so it may not directly access a data source. Please rebuild this data combination."}}],"exceptionCulprit":1}}} Table: users (2).