=Overview=
=Configuration - Essentials==Configuration - Advanced==Appendix===Options and Settings==<!--Explain all applicable misc options and settings that shouldn't be explained above hereThere are different ways to import OData Feed into Excel: Excel Data Tab, Power Pivot or Power Query...-->===General Settings==={| class="wikitable"|-||Option||Description||Example|-|||||||}below shows how to pull OData feed via the Excel Data Tab.
=Using Excel Data Tab==Display Settings==={| class="wikitable"|-||Option||Description||Example|-||||1. Go to the '''Data''' tab<br/>||2. Click '''From Other Sources'''<br/>|}3. Choose '''From OData Feed''' from the dropdown list
=Examples=<!-[[Image:OData-Excel1.PNG|400px]]
Sample Image Format:4. From the dialog box ''''Data Connection Wizard ''', enter the endpoint link and the credentials if using the private endpoint link.
[[FileImage:xmlSampleOData-Excel2.pngPNG|thumb|none|middle|500px|Example field configured as a budget sheet.400px]]
5. Select the report (collection) to import.
[[Image:OData-Excel3.PNG|400px]]
Sample Table Format:6. Click '''Next''' and then '''Finish'''
{| class="wikitable"| Option| Description| Example|[[Image:OData-|||Excel4a.PNG|}400px]]
[[Image:OData-Excel4b.PNG|400px]]
7. Data from report will be imported into Excel.
Sample Syntax Format[[Image:Empty space at start of line to highlight the row, italicize any variables that the user would fill in (as opposed to literal words that need to be used in syntax)OData-Excel5.PNG|400px]]
@section=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.''SectionNodeName''@
Sample Code Block:When you want to write an example block of code, you should highlight it and also escape any special characters that might be construed as HTML formatting and outputted incorrectly by the Wiki by using a pre (pre-formatted text) tag <pre><?xml version="1.0"?><Company> <Name>Oranges Inc.</Name> <Description>Peel. Eat. Repeat.</Description></Company><Company> <Name>Bananas Ltd.</Name> <Description>You're going to go "bananas" over our product!</Description></Company></pre> Unordered list:When listing information with bullet points in no orderSee Also=* [[Reports]]* Point 1[[Odata Overview|OData Overview]]* Point 2[[OData Connector]]* Point 3 Ordered list:When listing information with numbers [[SmartSimple OData Feed to denote ordered steps # Step 1# Step 2# Step 3 Sample Page Header Banners:Deprecated Feature<span class="mceNonEditable template" id="bs_template:@@@TPL0@@@" data-bs-name="Deprecated" data-bs-type="template" data-bs-id="0">{{ Deprecated }}</span>Deprecated Page<span class="mceNonEditable template" id="bs_template:@@@TPL1@@@" data-bs-name="DeprecatedPage" data-bs-type="template" data-bs-id="1">{{ DeprecatedPage }}</span>Professional Services<span class="mceNonEditable template" id="bs_template:@@@TPL2@@@" data-bs-name="Banner-Billable" data-bs-type="template" data-bs-id="2">{{ Banner-Billable }}</span>Page Under Construction<span class="mceNonEditable template" id="bs_template:@@@TPL3@@@" data-bs-name="Banner-UnderConstruction" data-bs-type="template" data-bs-id="3">{{ Banner-UnderConstruction }}</span> -->SQL Server Database]]