When adding OData to an Office 10 Excel Spreadsheet, the output does not download. The output appears on 1 line that is called Blackbaud, has a revenue ID of Blackbaud Query, and system record Id of 000000..., and record id of 0000.....
Upgrade to Office 2013 or higher to resolve.
Steps to Duplicate
1. Go to Analysis > Information Library > Search the query you would like to download. 2. Click the 2 down arrows to the left of the Query name > Select get OData link > Copy the link. 3. Open Microsoft excel and follow the following steps to download the OData into Excel. From the PowerPivot ribbon, click PowerPivot Window.
On the PowerPivot screen, click From Data Feeds under Get External Data.
In the Friendly connection name field, enter a descriptive name for your data feed, such as "Blackbaud CRM."
In the Data feed URL field, paste the URL you got from your query in Altru.
Click Advanced. On this screen, enter your Altru user name and password
Change your Integrated Security field from SSPI to Basic
Change the Persist Security Info field from False to True
Click Test Connection
Click Next, and select ODataQuery.ashx as the source table.
Once the import is complete, click Close.
4. You will now see that you only have 1 line of data with no useful information.