PBI REST API Import PBIX from OneDrive for Business

[jbrandt]

Hello!

I'm attempting to import a .pbix using the REST API referencing the file in OneDrive for Business as described in documentation here.  I am receiving an undefined 400 Bad Request error (no message) and am looking for guidance.  Can't find any examples for this method and I've tried using both Postman and Flow with the same results.  

From Postman the request looks like. 

POST /v1.0/myorg/imports?datasetDisplayName=TestReport HTTP/1.1
Host: api.powerbi.com
Content-Type: application/json
Authorization: Bearer <sanitized>
cache-control: no-cache
Postman-Token: 84b78aaf-8baf-45db-89f7-d9306b81d1dc
{
"connectionType" : "import",
"filePath" : "/pbix/BAL-Report-15-VaR-Waterfall.pbix",
"fileURL" : "https://fireappsoutlook-my.sharepoint.com/:u:/g/personal/<sanitized>/EVZgW1sjVaNAlPUGop0q<sanitized>..."
}------WebKitFormBoundary7MA4YWxkTrZu0gW--

With the following response: 

Content-Length →14

Content-Type →application/json; charset=utf-8

Strict-Transport-Security →max-age=31536000; includeSubDomains

X-Frame-Options →deny

X-Content-Type-Options →nosniff

RequestId →e1cc5b19-be7a-4aaa-bf75-6617f4141975

Date →Wed, 16 Jan 2019 19:10:02 GMT

{
"Message": ""
}

Is this a bug or is there a problem with the format?  Can someone provide a working example?   

Thanks in advance!

[v-qiuyu-msft]

Hi @jbrandt,

I have consulted this issue internally, will update here once I get information. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @jbrandt,

As this issue needs bigger investigation, I would suggest you create a support ticket to get dedicated support. 

Best Regards,
Qiuyun Yu 

[v-qiuyu-msft]

Hi @jbrandt,

I got reply from PG team: 

With OneDrive for Business only XLSX files are supported.

They will update the documentation. 

Best Regards,
Qiuyun Yu