PowerBi and Power Automate

[thankegyssling]

the use case is a generic HTTP POST to a REST API – Power Automate sends us a file as the body. This file should now be processed with Power BI.

Is there a supported way to achieve this?

Thanks in advance.

[tayloramy]

Hi @thankegyssling, 

Power BI can't directly access a file from a POST request. 

Power Automate would need to put the file somewhere that Fabric/Power BI can access it. The easiest place is prbably sharepoint, but you could also put the file in a Azure Storage Account in Azure data lake gen 2 storage, or you could use the storage APIs to shove the file directly into a lakehouse for Fabric to pick up. 

Regardless of which option you choose, you need to stage the file somewhere that Fabric/PowerBI can access it

[thankegyssling]

Hi
thanks for the fast response. as i know from the user the file will be delivered via HTTP Post
i have this informations:
Content-Type: application/vnd.openxmlformats-officedocument.spreadsheetml.sheet
Body: raw XLSX file

Is this helpfull?
Regards

Thorsten

[v-menakakota]

Hi @thankegyssling   ,
Thanks for reaching out to the Microsoft fabric community forum. 

If Power Automate is sending a file through an HTTP POST request, one option is to save the file in a location that Power BI/Fabric can access, such as SharePoint, OneDrive, Azure Blob Storage, or a Fabric Lakehouse. Power BI can then load and analyze the data from there.

Could you please share a few more details?

• What type of file is being sent (CSV, Excel, JSON, etc.)?
• Where is the REST API hosted?
• What would you like Power BI to do with the file after it is received?
  
  Best Regards, 
  Community Support Team