Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to 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
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.
Regards,
Xiaoxin Sheng
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