Forum Discussion
Ingest data via a webhook
While it is possible to set up a flow with a URL that can receive data you can then send to a Power BI dataset, I think it would be easier to have them email you the data in a consistent format (Excel, CSV, JSON, XML), and have a flow that is triggered from that email and then moves to file to SharePoint/OneDrive, and trigger refresh of your Power BI dataset that uses that SharePoint/OneDrive as the source.
Pat
Checked with them and don't think it's going to be possible mahoneypat. What would be the best way to create a URL that is capable of storing data in that case? Use a paid solution or try and code it up myself in python, say, which I have a reasonable knowledge and understanding of but I've never done data extraction this way around (normally use APIs rather than webhooks).
- mahoneypat5 years agoMicrosoft Employee
You can adapt the approach in this article (others out there too) to send data to a URL that triggers a Flow in which you can a save the data to SharePoint/OneDrive and then refresh the dataset that uses it as the source.
Pat