Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

how to post import pbix file

I would publish pbix file to a workplace using Post Import API

 

I'm trying to get file from One Drive 

 

here's my request

 

 

https://api.powerbi.com/v1.0/myorg/groups/cd936ccf-03ae-4df4-xxxxx/imports?datasetDisplayName=dataAutotest

 

 

 

Then in params I followed the doc but it's not really clear, examples are using different structure than doc.

 

Here's what I added In request Body

 

 

 

{
   "connectionType":"connect",
   "pathUrl":"https://org.sharepoint.com/:u:/g/personal/subdir/pbixfilepath"
}

 

 

 I get 400 error ( without details ) 

 

I have tried multiple combinations by replacing pathUrl with filePath or connectionType "connect" to "import".


I don't know if  OneDrive is supported, if not I'll be so grateful if someone could help me to import a pbix file with another way ( azure storage ? ) But I don't really get how to set correctly the body.

 

Here's the requestid 

requestid: 56ab064c-0cdf-48a0-8f7f-71b2f94ee0e8

 

  • Anonymous's avatar
    Anonymous
    5 years ago

    I have found a workarround, get file from azure container blob storage by downloading it using Azure-storage package then with node fs module import it in PBI

3 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    HI Anonymous,

    In fact, post import API seems not suitable with pbix file that stored in onedrive for business. I'd like to suggest you use 'onedrive for business' link of 'xlsx' files to test.

    Imports - Post Import#notes 

    • Importing a .pbix file from OneDrive is not supported.

    Regards,

    Xiaoxin Sheng

    • Anonymous's avatar
      Anonymous
      Not applicable

      I have found a workarround, get file from azure container blob storage by downloading it using Azure-storage package then with node fs module import it in PBI

      • Anonymous's avatar
        Anonymous
        Not applicable

        Hi Anonymous,

        Thanks for share the workaround, I think it should help for others who face similar issues.😊

        Regards,

        Xiaoxin Sheng