cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rbroida
Regular Visitor

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

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#importconflicthandlermo...

 

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:

 

 

7 REPLIES 7
yaniv-a
New Member

I have the same problem here for large files with premium capacity.

BadRequest is recieved when using either rest api or .net sdk v2.

The error happens after the pbix has been uploaded successfully to the temp blob location.

The http response is empty so there isn't any meaningful information to troubleshoot.

.pbix files <1GB are imported without issues.

 

I hope someone from Power BI team can look into it ASAP.

Can you please share your .Net sdk code to. Upload pbix?
I am facing this error when uploading a 10 mb pbix. I am on a pro account.
Help will be much appreciated as I am stuck on this for quite some time now.
integrationsupp
Frequent Visitor

Do we have an update or example for this ??

Dan2
Helper I
Helper I

Would like an answer to this as well

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.

 

How can I fix?

 

Thanks

 

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.

jbrandt
Frequent Visitor

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

Helpful resources

Announcements
PBI User Groups

Welcome to the User Group Public Preview

Check out new user group experience and if you are a leader please create your group

March Update

Check it Out!

Click here to read more about the March 2021 Updates!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.

secondImage

Experience what’s next for Power BI

See the latest Power BI innovations, updates, and demos from the Microsoft Business Applications Launch Event.