Using Power BI with Donorfy

Microsoft Power BI allows you to create visualisations based on your data. It is free, but with subscription for certain features.

To use Power BI with Donorfy you need to download and install the Power BI Desktop edition. This is a Windows application (will not run on a Mac).

Power BI retrieves data via the Donorfy data service, to use the data service you will need to find your API key - see this article for help with that.

Your link to the Donorfy data service will be https://data.donorfy.com/odata/<your api key> e.g. if your api key was abcdefgh your link would be https://data.donorfy.com/odata/abcdefgh

In Power BI Desktop:

  1. Click Get Data, and select OData Feed.
  2. Copy and paste this into the URL: https://data.donorfy.com/odata/XXXXXXX where XXXXXXX is your Donorfy API (find it in Donorfy, Settings, System Settings)
  3. Then you're prompted to log in:
    1. select Basic on the left hand side
    2. enter your Donorfy user name and password
    3. from the drop down box ("select which level...") choose the longest one, i.e. the one containing your Donorfy API key at the end.

Once connected you will be able to see the Data Source in Power BI, and you will have the Donorfy tables available to you. You will then be able to create reports and dashboards using your Donorfy data in Power BI.

 

Have more questions? Submit a request

Comments

Powered by Zendesk