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

Community site session details

Session Id :
Finance | Project Operations, Human Resources, ...
Answered

Filter by legal entity when exporting database in LCS

(1) ShareShare
ReportReport
Posted on by 38
When exporting the database of a UAT environment (sandbox) in lifecycle services, I want to filter the exportation by legal entity.
Means I don't want the bacpac file to contain all the legal entities.
Is there any way to filter before beginning with the export process?
I have the same question (0)
  • AB-24101041-0 Profile Picture
    38 on at
    Filter by legal entity when exporting database in LCS
     
    Thanks, much appreciated!
  • Verified answer
    Anthony Blake Profile Picture
    2,700 Super User 2025 Season 2 on at
    Filter by legal entity when exporting database in LCS
    Hi,
     
    Not possible unfortunately, the export/backup is a database level operation, and the legal entities are all in the same DB & tables. 
     
    You could investigate removing the other legal entities prior to the backup?
     
    Anthony
  • Jonas "Jones" Melgaard Profile Picture
    4,894 Super User 2025 Season 2 on at
    Filter by legal entity when exporting database in LCS
    It is not possible to do from LCS, since it does not understand the data model of F&O.

    If you only want specific legal entities in your BACPAC file, your best option is to import it into a staging environment, and clear out the data you don't want, and then export it from that environment.

    So some sort of data clearing process following your exports.
  • CU09091357-0 Profile Picture
    480 on at
    Filter by legal entity when exporting database in LCS
    I'm currently facing the same issue, when creating a bacpac file, I don't want to include all companies (legal entities) in it
  • Suggested answer
    Jonas "Jones" Melgaard Profile Picture
    4,894 Super User 2025 Season 2 on at
    Filter by legal entity when exporting database in LCS
    No, you cannot order LCS to export only specific legal entities.
    Question: Why do you only want to export some legal entities and not all?
     

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

Responsible AI policies

As AI tools become more common, we’re introducing a Responsible AI Use…

Abhilash Warrier – Community Spotlight

We are honored to recognize Abhilash Warrier as our Community Spotlight honoree for…

Leaderboard > Finance | Project Operations, Human Resources, AX, GP, SL

#1
CA Neeraj Kumar Profile Picture

CA Neeraj Kumar 2,258

#2
André Arnaud de Calavon Profile Picture

André Arnaud de Cal... 949 Super User 2025 Season 2

#3
Sohaib Cheema Profile Picture

Sohaib Cheema 631 User Group Leader

Last 30 days Overall leaderboard

Product updates

Dynamics 365 release plans