Forum Discussion
Source Control - Dataset Workload failed to import the dataset with dataset id
We have a devops git integration set up to make local changes to BIM files/ definition reports, which we then commit to our repo and push to the source control in the workspace on power bi service. I...
Please try like this:
{
"version": "1.0",
"datasetReference": {
"byPath": null,
"byConnection": {
"connectionString": "Data Source=powerbi://api.powerbi.com/v1.0/myorg/dev Datasets;Initial Catalog=\"Reporting EN\";Cube=Model;Access Mode=readonly",
"pbiServiceModelId": null,
"pbiModelVirtualServerName": "sobe_wowvirtualserver",
"pbiModelDatabaseName": "[DATASET ID],
"name": "EntityDataSource",
"connectionType": "pbiServiceXmlaStyleLive"
}
}
}
You can also get the exact connection string, by opening Power BI Desktop, connecting to the dataset (Live Connect) and Save as PBIP. Open the definition.pbir and there should be a similar connection like above.
RuiRomanoMS This works for me, and I really appreciate your assistance. Thank you so much 🙂