The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
How do I get the Dataset relationships through the API?
So, I am trying to call "client.Datasets.PostDatasetInGroupAsync(Guid groupId, CreateDatasetRequest dataset)"
I have the groupID, so I am trying to create the "CreateDatasetRequest dataset".
"CreateDatasetRequest " is a class that looks like this:
public string Name { get; set; }
public IList<Table> Tables { get; set; }
public IList<Relationship> Relationships { get; set; }
public IList<Datasource> Datasources { get; set; }
public DatasetMode? DefaultMode { get; set; }
I need the Tables, the Relationships and the Datasources.
My dataset is basically a copy of another dataset, and I am getting the information from the copied datasource.
I can get Tables like this: client.Datasets.GetTablesInGroupAsync(workspaceId, datasetID);
NOTE: client.Datasets.GetTablesInGroupAsync(workspaceId, datasetID); does not seem to work. it throws a NOT FOUND ERROR.
and the datasource like this: client.Datasets.GetDatasourcesInGroupAsync(workspaceId, datasetID);
But I cannot find a way to get the Relationships.
Is there a way that I can do this?
Connect to the XMLA endpoint and run your XMLA scripts aganst the DMVs. Use DAX Studio or similar to experiment with that.