PowerBI API is unreachable from Unity

[ep513140]

I have created a streaming dataset in PowerBI with an API which I am trying to POST to from Unity. I have created a C# script inside of Unity which is able to POST and GET from other APIs, but the PowerBI API always returns errors. I get a 404 error using GET and a 500 error using POST, I am able to POST from Postman and the Powershell, but neither of them are able to GET either. I believe there is some redirect URL happening that is confusing Unity and returning the 500 errror when I POST.

When I use Postman to test a GET request, I get the following error:

{

    "error": {

        "code": "",

        "message": "No HTTP resource was found that matches the request URI 'http://wabi-west-us-b-primary-redirect.analysis.windows.net/beta/c6f643f0-4f6b-47f1-90f2-d2ce068e698...<dataset>/rows?key=<key>'."

    }

}

This link is different from the api url given by Power BI which is 

https://api.powerbi.com/beta/c6f643f0-4f6b-47f1-90f2-d2ce068e6988/datasets/<dataset>/rows?key=<key>

Do I need to create an app registration? Is there a different URL from the one provided by PowerBI that will work better? 

[Anonymous]

Hi @ep513140,

Can you please share some more detail information about this issue? They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

[ep513140]

Here is my code which I am using:

The player Confidence and Experience are the columns in the API I want to write to. 

First I attempt a GET request which returns this error:

rows?experience=power-bi&key=<key>: HTTP Error: HTTP/1.1 404 Not Found

Then I attempt a POST request which gets this error: 

rows?experience=power-bi&key=<key>: HTTP Error: HTTP/1.1 500 Internal Server Error

As I have said above, the code works for other APIs but this PowerBI API will not let me post to it. Postman and Powershell are able to post to the PowerBI API but are unable to do a GET request with this error:

{

  "error":{

    "code":"","message":"No HTTP resource was found that matches the request URI 'http://wabi-west-us-b-primary-redirect.analysis.windows.net/beta/<string>/rows?experience=power-bi&key=<key>'."

  }

Let me know anything else I can do to provide clarification, I have been trying to figure this out for a month. 

}