Forum Discussion
Source Control - Dataset Workload failed to import the dataset with dataset id
Hi RuiRomanoMS
I'm having the same issue for the moment. but scenario is bit different.
Scenario:
I have one AAS model in Azure Analysis Services and I migrated it in to the Premium Workspace using Azure Analysis services migration feature. and I have some Power BI reports in Fabric and now I want to connect it to the newly migrated semantic model and sync those reports to a newly created workspace. I tried to do it using Fabric Git Integration with Power BI PBIP file. I download the PBIX file then change the source connection to newly migrated semantic model and I saved it as a PBIP file in my local clone folder and I commited those changes to DevOps and sync it with the new workspace. And I got this error message.
Is this happend because I'm using direct query in Power Bi reports? I found below article.
https://learn.microsoft.com/en-us/fabric/cicd/git-integration/git-integration-process#considerations-and-limitations
and it saying "Direct Query and composite models on Power BI Datasets and Analysis Services aren't supported at this time."
Is this the reason?
If so, when is this going to be available?
DirectQuery and Composite models on Analysis Services dont work, but if I understood correctly that's not your scenario. You migrated the AS to a Power BI dataset and should be supported.
Can you share the definition.pbir of the report? Does it look like this: Power BI Desktop project report folder - Power BI | Microsoft Learn
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 youPlease 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 🙂