better way to automate data ingestion from third party rest api's
I am new to power bi. I was asked to automate the data ingestion from a third party rest api's and make this data available for power bi reports.
Currently I built a Azure's logic app which gets the data from third party rest api and transforms the data and push it to power bi streaming push datasets.
I am not sure if its an ideal/best solution for this requirement as I see few power bi apps like Salesforce, Google Analytics etc.. where we can directly connect and get data incrementally (through scheduled refresh).
I need a review/comments on the approach I used and also is there a better way to automate the data ingestion?
My customer is not very technical and they just want a system which is less maintainable. Any help would be highly appreciated.
My understading is that the data is descrete in nature. Customer is looking to see the reports for last 9 months of data. I don't think they value the difference between snapshot and event based reports.
Currently I'm pulling the data from third party system through rest apis. Third party system stores the data and we can pull it anytime we want through their rest apis. So is it feasible to build a custom connector for this api and pull the data similar to salesforce?