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