In an earlier post, I described how to set up Postman to test calling your AX data entities. https://daxvisionerp.com/call-ax-data-entity-from-postman/
You can also read data from AX data entities using Excel. It is easy, no need for secret and token, etc, you just need to log in with your AAD credentials. Let me quickly show the steps using VendorsV2 entity: ‘https://usnconeboxax1aos.cloud.onebox.dynamics.com/data/VendorsV2’
![Machine generated alternative text:
ktops Tools Help
Data management Finance 2 r
"@cdata.contat":"https://usnc
, -Bank' r
"@odäti. t g
A Not secure
" , SSLva
V do Sea
usnconeboxaxlaos.cloud.onebox.dynamcs.com/dataNendorsV2
• , "DefaultOffsetLedgerArccuntOisol—yV lue
7me"
" Ethnicoriginld"-""
pld" • " ,
, , ; "No" , .
• " , • Vendwp.rtyryge"
ntCod "
• Vendwp.rtyryge"
" , "o:crcge
e" • "SSIva
"Kote
"19ae-e1-
a e" "Florida State
INSSCa•: •
"SSIVa1idfty5ate•
" wee-el -](https://daxvisionerp.com/wp-content/uploads/2020/02/VendorsV2.png)
- Click ‘Data/New Query/From Other Sources/From OData Feed’
![Machine generated alternative text:
Home Insert
Page Laput
Formulas
Review View Add-ins
Team Tell me what you want to dc
From From From From Other Existing
Access Web Text Sources • Connections
Get External Data
Show Queries
From Table
Recent Sources
From
From patabase
Fro m Azure
Fro m Other Sources
Combine Queries
Data Source settings...
Query Okti ons
Connections
Properties
Refresh
All Edit Links
Con
Fro m
z I Sort
Reapply
Filter
Advanced Colun
sort & Filter
From SharePoint List
Fro m OData Feed
From Hadoop File (HDFS)
• From Directo ry
From Qynamics 365 (online)
m Microsoft](https://daxvisionerp.com/wp-content/uploads/2020/02/1ODataExcel.png)
2. Set data entity OData feed URL
![Machine generated alternative text:
Home Insert
P age Layout
Formulas
Review View Add-ins
Team Tell me what ycu want to dc...
Show Queries
El Connections
From Table
Properties
Refresh
Query. Recent Sources All . Edit Links
Shmv Detail
Hide Detail
From From From From Other Existing
Access Web Text Sources • Connections
Get External Data
z I Sort
Reapply
Filter
Text to
Flash Retnove Data Consolidate Relationships Manage
Fill Duplicates Validation
Data Model
Data Tools
OData feed
@ Basic C) Advanced
What-If Forecast
Analysis Sheet
Forecast
Group
V• Advanced Columns
Get & Transform
Con
sort & Filter
Ungroup Subtotal
outline
he C namiCS.COm/data.NendOrsV2](https://daxvisionerp.com/wp-content/uploads/2020/02/2ODataExcel-1024x389.png)
The first time you will get a login dialog after clicking the ‘OK’ button.
3. Load
![](https://daxvisionerp.com/wp-content/uploads/2020/02/3ODataExcel-1024x514.png)
![](https://daxvisionerp.com/wp-content/uploads/2020/02/3.5ODataExcel-1024x403.png)
4. Result in Excel, data loaded
![](https://daxvisionerp.com/wp-content/uploads/2020/02/4ODataExcel-1024x406.png)
So, this way you can easily load your data to Excel and get a comfortable format.
I used this post as reference: https://wem.io/documentation/tips-and-tricks/data/odata-excel2016/