OData in Microsoft Excel 2013

In Microsoft Excel 2013, you can create power views using the OData information.

Note: If this is your first time using OData in Excel, click Options and make sure you have the Power View add-in. Select "COM Add-ins." Then, select Power View and Microsoft Office PowerPivot for Excel 2013 and click OK.

  1. From the Data tab, select From Other Sources/From OData Data Feed.

  2. Paste the URL you got from your query in Altru and enter your credentials.

    Tip: Your user name needs to include your Blackbaud domain name "blackbaudhost." So in this example your user name for the credentials would be similar to "blackbaudhost\johndoe."

  3. Click Next.

  4. Check the "ODataQuery.ashx" checkbox.

  5. Click Next.

  6. You can enter a description and change the name if you prefer.

  7. Click Finish, and then click OK to import the data.

  8. On the Import Data screen, select "Power View" and click OK. You can now use Excel to create charts and dashboards of your data.