you can query from custom table : select Id as "Id", RECORD_Name as "RecordName" FROM svc_ref_entities sre WHERE sre.attribute_category = 'XX_EBS_STOCK_DTL_c' then create csv file to import (Tools → Import Management ) here's sample csv file : Id,RecordName 100000679953191,SCM_RECORD_19…

I Faced the same issue, and found the KEY should be the same in Bursting Split By and Deliver By and should be also in main Data Model. Also you can change Bursting Split By and Deliver By manually, it accepts editing, not use list of values.

I found workaround, that's to add data set with only the key column, then make this dataset as parent to excel dataset, and join both. Then goto Bursting query and choose Parent query with key column, as the group by