The OData feature will allow you to connect the data generated from a query to Excel or Tableau. If you are working on Excel for Mac, you may not be seeing the correct options on the Data Tab to import the OData data feed.
Blackbaud is unable to address this issue because it is related to third-party software. For assistance contact the third-party vendor. Currently Microsoft does not support any OData connection option for Excel for Mac. In addition, Excel for Mac does not support Power Pivot, Power View, Power Query, or Power Maps.
For more information about this issue, please refer to Microsoft's website and ideas below:
Note: We provide links to third-party websites in an effort to help you resolve your issue. We are not responsible for the information on third-party websites and we cannot assist with implementing resolutions from these websites.