Forum Discussion
Solved
PowerBi and Power Automate
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...
- You’re very close — and no, you don’t need a custom connector for this.The key point is that Power BI cannot consume a file directly from an HTTP POST request. The file needs to be stored first in a location that Power BI/Fabric can access.The usual pattern is:
- Power Automate receives the HTTP POST
- Save the file to SharePoint / OneDrive / ADLS / Lakehouse
- Power BI reads the file from that location
Regarding your questions:- You do not need a custom connector for this.- A gateway is only required if the file is stored in an on-premises location.- If you store the file in SharePoint or OneDrive Online, Power BI can access it as a cloud source.Official Microsoft references for the building blocks:- Power Automate HTTP request trigger / authentication:
https://learn.microsoft.com/en-us/power-automate/oauth-authentication - SharePoint connector actions in Power Automate:
https://learn.microsoft.com/en-us/sharepoint/dev/business-apps/power-automate/sharepoint-connector-actions-triggers - Power Query SharePoint Folder connector for Power BI/Fabric:
https://learn.microsoft.com/en-us/power-query/connectors/sharepoint-folder
A closer step-by-step example of the exact pattern, HTTP POST file upload to Power Automate and then SharePoint, is here:
https://blog.ninethsense.com/technology/automation/power-automate-post-a-file-to-trigger-a-http-flow-and-upload-to-sharepoint/So the important part is the staging step: receive file → store file → let Power BI read it. Power BI is pull-based, while your HTTP POST scenario is push-based.
Hi
no sorry
Hi thankegyssling ,
No problem. Please take your time. Once you've had a chance to test it, let us know how it goes or if you run into any issues. We'll be happy to help further.