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.
What is the nature of the data? What are the customer expectations in terms of keeping historical data? Does your customer value the difference between snapshots and event based reports?
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.
Use an external process (Power Automate, PowerShell or whatever tool you like) to pull the data from the source and stuff it into a SQL Server database. Then use that as the source for Power BI.
Power BI is not a data storage tool, it is a reporting tool. Don't use it for storage, especially not for data you cannot recover in other ways.
Thank you for the suggestion.
How does it works when we connect the salesforce objects or any standard connectors from power bi directly? I believe its stored in power bi datasets.
It's stored in Salesforce.com. Power BI datasets are just there for the consumption. If your dataset goes bad/gets corrupted/deleted you can always re-load the data from Salesforce.com.
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?
This is a must watch for a message from Power BI!
Click here to read more about the December 2020 Updates!
Click here to read the latest blog and learn more about contributing to the Power BI blog!
Mark your calendars and join us for our next Power BI Dev Camp!.