web
You’re offline. This is a read only version of the page.
close
Skip to main content

Notifications

Announcements

No record found.

News and Announcements icon
Community site session details

Community site session details

Session Id :
Dynamics 365 Community / Forums / Finance forum / Web Services Excel mul...
Finance forum

Web Services Excel multiple tables

(0) ShareShare
ReportReport
Posted on by Community Member

Hello,

I created a new Query for Object ID 261 (GL Entries). I added the table in excel using the Excel Add-in and I can see the data for that table. However I am trying to add an additional table DimensionSetEntries - DimensionSetEntries so I can pull the dimension description into excel. I receive this message:

Unable to add new data as data already exists at this location

Is it possible to pull from multiple tables?

Thanks!

Categories:
Development / Customization / SDK
I have the same question (0)
  • Suggested answer
    Mea_ Profile Picture
    Mea_ 60,284 on at

    Hi Juliet Constantino,

    You dont need to add another entitiy, instead you(or your developer) need to do a small change and you will get dimensions in all excel templates, please refer for details https://docs.microsoft.com/en-us/dynamics365/unified-operations/dev-itpro/financial/dimensions-overview

     

  • Community Member Profile Picture
    Community Member on at

    Thanks for the info. I will need to install visual studio and then attempt this. In the meantime, is it possible to add additional entities/tables in the excel add-in? I've ran into this a few times before and would be helpful.

  • Mea_ Profile Picture
    Mea_ 60,284 on at

    Let me clarify first, are we talking about AX or D365 ? For D365 you can add additional entities not tables and you don't need to install VS it is already installed on VM that hosts application.

    If you asked about AX then it's a wrong forum.

  • Community Member Profile Picture
    Community Member on at

    This is for Dynamics 365 Business Central. When I use the excel add-in it doesn't let me add additional entities.

  • Mea_ Profile Picture
    Mea_ 60,284 on at

    This forum is for "Dynamics 365 for Finance and Operations Forum", so you probably want to ask your question in the Business Central related forum...

Under review

Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.

Helpful resources

Quick Links

November Spotlight Star - Khushbu Rajvi

Congratulations to a top community star!

Forum Structure Changes Coming on 11/8!

In our never-ending quest to help the Dynamics 365 Community members get answers faster …

Dynamics 365 Community Platform update – Oct 28

Welcome to the next edition of the Community Platform Update. This is a status …

Leaderboard > Finance

Last 30 days Overall leaderboard

Featured topics

Product updates

Dynamics 365 release plans