cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
rbroida Frequent Visitor
Frequent 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
jbrandt Frequent Visitor
Frequent Visitor

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

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

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

Would like an answer to this as well

Highlighted

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

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

 

atsats Frequent Visitor
Frequent Visitor

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

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.

integrationsupp Frequent Visitor
Frequent Visitor

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

Do we have an update or example for this ??

yaniv-a Occasional Visitor
Occasional Visitor

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

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.

integrationsupp Frequent Visitor
Frequent Visitor

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

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.

Helpful resources

Announcements
Coming Soon: T-Shirt Design Contest

Coming Soon: T-Shirt Design Contest

Keep your eyes open for our upcoming T-shirt design contest!

Meet the 2020 Season 1 Power BI Super Users!

Meet the 2020 Season 1 Power BI Super Users!

It’s the start of a new Super User season! Learn all about the new Super Users and brand-new tiered recognition system.

Super User Challenge: Can You Solve These?

Super User Challenge: Can You Solve These?

We're celebrating the start of the New Super User season with our first ever Super User 'Can You Solve These?' challenge.

Power BI Desktop Update - February 2020

Power BI Desktop Update - February 2020

We are super excited for our update this month, as we are releasing two of our top community requests!

Power Platform Online Conference

Power Platform Online Conference

Join us for the first ever Power Platform Online Conference!

Top Solution Authors