Forum Discussion

ep513140's avatar
ep513140
Frequent Visitor
2 years ago

PowerBI API is unreachable from Unity

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 
 

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

2 Replies

    • ep513140's avatar
      ep513140
      Frequent Visitor

      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. 
      }