Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago

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...
Need Help
RuiRomanoMS's avatar
RuiRomanoMS
Microsoft Employee
2 years ago

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.

YoussefMejri's avatar
YoussefMejri
New Member
2 years ago

Hi I'm struggling with the same issue .. in a diffrent senario .. I have a report that visualizes the data from SQL server data base (In an Azure VM) .. I'have merged the report as PBIP project to an Azure devops repo .. and when trying to synchronise my Power BI PPU workspace, with my Azure devops git repo I get the same error mentioned above, the definition.pbir content is : 
{
"version": "1.0",
"datasetReference": {
"byPath": {
"path": "../Delivery_Report.Dataset"
},
"byConnection": null
}
}