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
samudralb's avatar
samudralb
Frequent Visitor
2 years ago

RuiRomanoMS 

I really appreciate your reply. 

pbir file looks like this. 
Any suggetions?

{
"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": null,
"pbiModelDatabaseName": null,
"name": "EntityDataSource",
"connectionType": "analysisServicesDatabaseLive"
}
}
}

Thank you


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.

  • samudralb's avatar
    samudralb
    Frequent Visitor
    2 years ago

    RuiRomanoMS This works for me, and I really appreciate your assistance. Thank you so much ðŸ™‚

  • 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
    }
    }