You’re offline. This is a read only version of the page.
4
Hi, is there a way I can export my dataverse table to include the relationships. I have the following schema.
dbo.storeData
dbo.areaManagerData
dbo.ownerData
dbo.region
dbo.masterData
All connected with different relationships from N:1, 1:N and N:N.
When I export the table (dbo.ownerData) from dataverse there's no indication to the relationship it has to the dbo.storeData or dbo.region.
So I have a N:N relationship between the dbo.ownerData and dbo.storeData. So all I would like to see is an export of the dbo.ownerData that shows me the owner table with the store(s) connected to that owner or an export of the dbo.storeData that shows me the owner(s) connected to this store.
Is there a way without using a Powe Automate solution? I guess one solution would be to build a collection in Power Apps, but then this still requires a Power Automate solution to export to .csv
Oh I see - you want an export of data with the 1:N related data, not the schema. The issue is how to display this in a single row when you export. There are a couple of options here.
Thanks for this. Did not try the solution yet, will get back to you on this.
My end goal is that business might ask for a dataset (usually in .csv format) with all owners with their details as well as the stores they own. In dbo.ownerData I have three columns (nameSurname, tel, email). I use a N:N relationship between dbo.ownerData and dbo.storeData to relate the correct store(s) to the correct owner(s). Now if I export the dbo.ownerData then it only gives me the 3 columns, with other internal columns, in a .cvs file but not the related data/info. I have tried exporting the dbo.storeData as well with the same result.
I use the export function at the top to export data (see attached)
How are you currently exporting the table? And what’s your end goal for the export? It seems like you want to export the schema but then you mentioned CSV files…
To export the schema, table definition, as well as the relationships you need to create a ‘solution’ in the maker portal and add your tables there. Then you can export the solution - which can include several tables, flows, web resources, apps, etc - and it creates a zip file. You can easily import this into another Dataverse environment and recreate all your tables (minus the data).
Now if you want to export data from the tables, you can export to CSVs or Excel files. It is data only and won’t include data types or relationships. However the re-import lets you map the data back into relationships if you need to do that. Other import solutions are using dataflows or power automate.
now if you’re trying to export a table definition and include data at the same time, I don’t think that’s possible. If you want the table schema in a text friendly way - XrmToolbox has a tool that documents a Dataverse solution and exports it to an excel.
#1
mmbr1606
22
Super User 2025 Season 1
#2
stampcoin
19
#3
Michael E. Gernaey
15
Super User 2025 Season 1
Share
Report
All responses (
Answers (
