Difference between revisions of "SmartSimple OData Feed to Excel"
From SmartWiki
(Created page with "=Overview= =Configuration - Essentials= =Configuration - Advanced= =Appendix= ==Options and Settings== <!--Explain all applicable misc options and settings that shouldn't be e...") |
(→Using Excel Data Tab) |
||
| (15 intermediate revisions by the same user not shown) | |||
| Line 1: | Line 1: | ||
=Overview= | =Overview= | ||
| − | + | There are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query. | |
| − | + | Example below shows how to pull OData feed via the Excel Data Tab. | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | == | + | =Using Excel Data Tab= |
| − | + | 1. Go to the '''Data''' tab<br/> | |
| − | + | 2. Click '''From Other Sources'''<br/> | |
| − | + | 3. Choose '''From OData Feed''' from the dropdown list | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | + | [[Image:OData-Excel1.PNG|400px]] | |
| − | |||
| − | + | 4. From the dialog box ''''Data Connection Wizard ''', enter the endpoint link and the credentials if using the private endpoint link. | |
| − | [[ | + | [[Image:OData-Excel2.PNG|400px]] |
| + | 5. Select the report (collection) to import. | ||
| + | [[Image:OData-Excel3.PNG|400px]] | ||
| − | + | 6. Click '''Next''' and then '''Finish''' | |
| − | + | [[Image:OData-Excel4a.PNG|400px]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | | | ||
| + | [[Image:OData-Excel4b.PNG|400px]] | ||
| + | 7. Data from report will be imported into Excel. | ||
| − | + | [[Image:OData-Excel5.PNG|400px]] | |
| − | |||
| − | + | =Troubleshooting= | |
| + | <!--see ticket 69942 - OData with https gives error--> | ||
| + | 1. TLS1.2 security protocol should be enabled on your local machines before you can import OData with HTTPS link. By default, MS Office do not accept this protocol by default. | ||
| − | + | =See Also= | |
| − | + | * [[Reports]] | |
| − | + | * [[Odata Overview|OData Overview]] | |
| − | + | * [[OData Connector]] | |
| − | + | * [[SmartSimple OData Feed to SQL Server Database]] | |
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | * | ||
| − | * | ||
| − | * | ||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
| − | |||
Latest revision as of 15:53, 24 July 2018
Overview
There are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query. Example below shows how to pull OData feed via the Excel Data Tab.
Using Excel Data Tab
1. Go to the Data tab
2. Click From Other Sources
3. Choose From OData Feed from the dropdown list
4. From the dialog box 'Data Connection Wizard , enter the endpoint link and the credentials if using the private endpoint link.
5. Select the report (collection) to import.
6. Click Next and then Finish
7. Data from report will be imported into Excel.
Troubleshooting
1. TLS1.2 security protocol should be enabled on your local machines before you can import OData with HTTPS link. By default, MS Office do not accept this protocol by default.
