Extract relationships and table data to csv

[10xape]

Hi

Is there any option to extract all relationships and table data (or at least sample) from a workspace model to a csv file?

Thanks

Matt

[otykier]

Do you wish to extract the data in an automated way? If so, you can use the C# script feature. However, please be advised that querying large amounts of data in one go can potentially cause memory issues on both the server and client side. If your table has many rows (say, more than 100.000) you may want to write some code to process it in batches, e.g. using the TOPNSKIP DAX function.

We also have an Export data... option in the Query menu, after you've executed a query. But please note this has the same limitation as mentioned above. It may be useful for just exporting a sample of data as Excel / CSV, but again, if you have many rows, this technique will not work do to memory constraints.

For exporting relationships, could you please clarify what you need? Is it just the list of relationships? In that case, you could use a C# script like this:

ExportProperties(Model.Relationships, "FromColumn,ToColumn,IsActive,CrossFilteringBehavior")
    .Replace("\t", ",")
    .Output();

[10xape]

yes I just need data samples and all relationships basic info, like what it realtes to.

[10xape]

what would be the script to export the masures?

[otykier]

Just a list of measures? That would be:

ExportProperties(Model.AllMeasures).Output();