Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
ITInge
Frequent Visitor

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

 

1 ACCEPTED SOLUTION

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

View solution in original post

3 REPLIES 3
v-shex-msft
Community Support
Community Support

HI @ITInge,

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

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

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

Hi @ITInge,

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

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Fabcon_Europe_Social_Bogo

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.