Forum Discussion
Pipedrive Integration
To import data into a publish report, you can follow this toturial, Push data into a Power BI dashboard. Power BI Services provides the APIs that are also JSON based. Just call the Pipedrive API, reform and send the returned JSON to Power BI services, say in C#, and schedule a windows task to import in a certain interval automatically.
Thank you both for the suggestiosn - I've now experience in either of these methods but will try them out when we get to that point. Either way it's reassuring that accessing the data should be possible.
Much appreciated.
You can’t connect Pipedrive with PowerBI directly without coding, but there are several approaches to consider. You can replicate your data to the data warehouse (BigQuery, Redshift, etc) with the help of Skyvia and then connect it to PowerBI. Another way is to use Odata connector.
I have tried to use the Odata connector but I've had no luck. Any suggestions?