This time, I wanted to add a Map and answer to the question “What If I cannot install the MDX plugin in Excel?”.
Our integration is done with an anonymous OData service.
In MS Excel, it’s as simple as going to the Data ribbon, then From other sources and then choosing From OData feed:
Note: If you have the Power Query add-in, the wizard from the “New Query” menu is a bit more friendly and allows for basic authentication. The steps are pretty much the same.
Paste the URL to your .xsodata service (you can leave the sign-in options as they are, since your service is anonymous):
And choose from the tables you want:
Fill in the name and description of your feed in the next step and let the data in:
Now I have a table with cities, that can be mapped into the Bing Maps add-in from MS Excel:
Select the data from your table and click on the “pin” icon on the top right corner of the map add-in for it to include it as a source… Ta-da!