topic Re: PowerBI API is unreachable from Unity in Developer

PowerBI API is unreachable from Unity

ep513140 — Wed, 03 Jan 2024 16:24:52 GMT

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?

Re: PowerBI API is unreachable from Unity

Anonymous — Thu, 04 Jan 2024 02:35:10 GMT

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

Re: PowerBI API is unreachable from Unity

ep513140 — Thu, 04 Jan 2024 15:12:42 GMT

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.

}