Power BI Admin API working in Desktop but in service unable to refresh datasets

[Sm0707]

Hello, I am trying to make a report for all the worksapces and reports using Power Bi Admin API.

I am able to refresh datasets in desktop but when i published the report in service i am not able to configure it.

URL Used - https://api.powerbi.com/v1.0/myorg/admin/groups?$top=1000&$expand=datasets

[Sm0707]

Just to add-

I am using a function to get the jwt token then invoking the function in the other data source.

Could it be the second data source isn't able to get the JWT token from function, causing the auth problem? 

[Sm0707]

If you are talking about this then it would still be the same URL in the datasource so it is still not resolving the issue.

[ibarrau]

Hi! I think I have seen this before. Did you tried skipping test? The thing with APIs when you are doing the auth in headers with token is that is difficult for service to capture and understand the anonymous. Try skip, I have seen that working in another post. They where using relative path leaving a smaller url, but I think it should work anyway.

I hope that helps,

[Sm0707]

Yes, skip test was my first choice.

As I have a function which is getting the JWT and then passing on to the query where this dataset is being used. So, I did that at first then when that didn't work I tried all other auth options but nothing could get it resolved.

Also just to mention it worked 7-8 months ago for a different client, having a feeling something may have changed which is not part of the MS documentation.

[ibarrau]

Ok. Then you might want to try using relative path for the Web.Contents keeping the URL for just "https://api.powerbi.com/" . The rest of the url would be the relative path. Let's see if that way PowerBi Service can read it.

I hope that helps