Imports.Postimportingroup() in .NET SDK returns 400 Bad Request

Question

Using the .NET SDK, I want to programmatically import a dataset, which is defined in a .PBIX file stored in OneDrive for Business, into an app workspace. The method PowerBIClient.Imports.PostImportInGroupAsync() is supposed to accomplish this. However, I get inscrutable 400 Bad Request errors whenever I call it.

Microsoft doesn't seem to have any online documentation of this .NET SDK method. (There doesn't seem to be complete reference documentation to the .NET SDK, period.) There is documentation for the underlying REST API here:

https://docs.microsoft.com/en-us/rest/api/power-bi/imports/postimportingroup#importconflicthandlermode

What I don't see is any explanation of what the "ImportInfo" (sent as message body in the REST API) should contain. It has three properties, all strings: FilePath, FileUrl, and ConnectionType. I believe ConnectionType is supposed to be set to "import", but I don't know what the proper for is for FilePath or FileUrl, and I have found no examples.

Could someone please explain, preferably with an example, how to call this SDK method successrfully?

Code in C# is essentially this:

marcogammella · Answer

I have the same problem with this api.I try to call the api from Sdk V2 "PostImportWithFileAsyncInGroup" and also create a post to this url "https://api.powerbi.com/v1.0/myorg/groups/{groupID}/imports?datasetDisplayName={name}": the response is always BadRequest.&nbsp;How can I fix?&nbsp;Thanks&nbsp;

andrask · Answer

Having the same issue here. Attaching SDK C# code.

var importUrl = $"https://api.powerbi.com/v1.0/myorg/groups/{targetWorkspaceId}/imports?datasetDisplayName={reportName}&nameConflict=Ignore&skipReport=false&overrideReportLabel=true&overrideModelLabel=true";
var importRequest = new { fileUrl = recievedUploadUrl };
var importResponse = await httpClient.PostAsync(importUrl, new StringContent(JsonConvert.SerializeObject(importRequest), Encoding.UTF8, "application/json"));

jbrandt · Answer

Looking for this info as well, did you ever find any examples?

dan2 · Answer

Would like an answer to this as well

atsats · Answer

I'm also getting the Bad Request response - pretty amazing that more than a year after the question was first asked the question is still unanswered and the documentation is still woefully inadequate.

What a waste of time for developers to reverse-engineer APIs that should've been documented in teh first place.

Forum Discussion

Imports.Postimportingroup() in .NET SDK returns 400 Bad Request

9 Replies

Related content

Gateway installation error - Network request returned unexpected errors

TopN filter returning more than requested

Feature Request: Matrix Visual

Invoke Pipeline Returns "Could not found the requested item"

Measure returning incorrect value