OData Support for Private Datasets
Users can now read private datasets from Socrata Open Data sites on Excel using the OData URL. This enables further analysis of datasets using Microsoft Excel, PowerBI, Tableau and other OData-compatible analytics tools.
- Connect to datasets by following the instructions described in Analyze Socrata Data In Microsoft Excel® Using Socrata Open Data Connector support article.
- Unlike with public datasets, the client, e.g. Excel or Tableau, will prompt you to enter your Socrata credentials to ensure you have permissions to view the private datasets.
- Now you can seamlessly keep your Odata instance of both private and public datasets up to date when you use these OData enabled analytics tools.