web

You’re offline. This is a read only version of the page.

News and Announcements icon

Dynamics 365 CommunityForums Microsoft Dynamics AX (Archived) AOT query new fields a...

Microsoft Dynamics AX (Archived)

AOT query new fields are not displayed in Excel while using Odata feed from Power Query.

(0) Share

Report

Report

Posted on by Rati Sharabidze

612

Hello all,

I have added some datasources and fields in an AOT query and I want to display them in Excel via Odata.

I only see old fields. I have tried:

1) refresh dictionary,data,elements.

2) deactivate and activate the query in the document sources.

None of those 2 options worked.

Can you please tell me how can I get the new fields?

I am using AX 2012 R3.

Thank you in advance!

BR

*This post is locked for comments

I have the same question (0)

All responses Img

All responses (2)

Answers Img

Answers (1)

Sort by

Suggested answer

Rustem Galiamov 8,072 on at

Like (0)

Report
Copy link

Link copied!

Hi Rati Sharabidze!

Try to partial or full CIL and restart AOS.

Was this reply helpful? Yes No
Verified answer

Rati Sharabidze 612 on at

Like (1)

Report
Copy link

Link copied!

Hello,

Apparently, excel had issues, I deleted all temp files in temp folder (shortcut %temp%).

Then it worked.

Thank you for your help.

Best regards

Was this reply helpful? Yes No

Helpful resources

Quick Links

Leaderboard > 🔒一 Microsoft Dynamics AX (Archived)

#1

CP04-islander 16

#2

#3

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans