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 altered a bim file in tabular editor to add a table into a dataset, committed the change in git desktop to our local devops repository and tried to then update the source control on the power BI service and received the following update error:

Cluster URI https://wabi-uk-south-redirect.analysis.windows.net/

Request ID 199ce683-c394-a2be-5f65-82738e01c577

Workload Error Code Dataset_Import_FailedToImportDataset

Workload Error Message Dataset Workload failed to import the dataset with dataset id ae819801-e0a4-4dc1-af3a-467ff894f290 Time Wed Sep 13 2023 08:02:45 GMT+0100 (British Summer Time)

Need Help

18 Replies

  • tex628's avatar
    tex628
    Community Champion
    2 years ago

    Hi RuiRomanoMS 

    I'm having the same issue as above. All definition files are running without issue but trying to open a model.bim file with PBI Desktop returns "/model.bim is missing a valid file name extension" (this is translated). 

    I made just a small visual adjustment to a definition file when this started. Didn't even make any adjustments to the datamodel. 

    Br, 
    Johannes

  • alfBI's avatar
    alfBI
    Responsive Resident
    2 years ago

    We are suffering same issue.

     

    In our case we the pbip was only modified using PBI Desktop. The dataset includes a simply table created with Power M

     

    Sample Table = {1}
     
     
    Alfons
      • alfBI's avatar
        alfBI
        Responsive Resident
        2 years ago

        Hi Rui,

         

        It is a simply pbix with with a calculated table created using DAXX

         

        Sample Table = {1}

         

        Should be easy to reproduce it.

         

         

        To get rid of the issue we workarounded  the problem by replacing the DAX calc table by a table imported from excel.

         

  • RuiRomanoMS's avatar
    RuiRomanoMS
    Microsoft Employee
    2 years ago

    We are working to improve the error message and include more details.

    Can you try to open the model.bim in Power BI Desktop, it should fail and let you know what is the error.

  • tex628's avatar
    tex628
    Community Champion
    2 years ago

    I have an update in regards to this. 

    Initially i tried to update multiple times, the update would load for several and then return the above error. 
    After a few days of this i opened a support ticket in regards to the issue. 

    On the session with the MS Support the update loaded for several minutes but finally synced after roughly 7 or 8 min. 

    Accordning to the trace there were several events that timed out during the process, but as the update synced in the end we do not know what was causing the issue and what resolved it. 

     

    Now the updates are imidiate, as you would expect. 

    • Anonymous's avatar
      Anonymous
      Not applicable
      2 years ago

      Hi tex628 , thanks for the update! You also mentioned before that you were unable to open de model.bim file, is that resolved now too and can you open it?

       

      I'm having the same problem 

  • samudralb's avatar
    samudralb
    Frequent Visitor
    2 years ago

    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?

      • 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