Forum Discussion
Theo_MS
Advocate I
Advocate IPublish report issue with power automate
Hello, I am having issue to publish a report throw a power automate. The purpose of this flow is for a public user to report (via the main service account) on a Fabric workspace via API. The ...
Here's the solution based on this article Use Power Automate HTTP Connector to Publish .pbix File Using the Power BI API – Joel Leichty
The HTTP step need the authentification by Active Directory OAuth.{
"$content-type": "multipart/form-data",
"$multipart": [
{
"headers": {
"Content-Disposition": "form-data; name=\"Rapport\"; filename=\"Rapport.pbix\""
},
"body": @{base64ToBinary(triggerBody()?['file']?['contentBytes'])}
}
]
}
lbendlin
Super User
Super UserYou will need to create and use a custom connector for the Power BI REST API calls. It is not possible to authenticate the way you are attempting to. The custom connector will handle the authentication for you.
Theo_MSHI lbendlin,
thanks for your reply.
Can you elaborate a bit more ?
I have set the Power BI connector, but there is no action to import a report:Regards,
Théo- lbendlin
You will need to create and use a custom connector for the Power BI REST API calls.
Custom connectors overview | Microsoft Learn