Locating the unique identifier for a dataset within PowerBI

[PMFlorenzano]

Hello,

I just recently migrated one of my Azure Analysis Services models to Power BI Premium and I'm now looking to migrate the reports to the new semantic model.

From what I understand and read, this can be accomplished by editing the definition.pbir file which I've done, but one of the required fields is to include the unique identifier for the target dataset in the Microsoft Fabric service, but I'm uncertain where to find this unique identifier.

Any suggestions would be greatly appreciated.

Thank you

[GilbertQ]

Hi @PMFlorenzano 

You can log into the power BI service then in your semantic model, click on three dots and select settings. When you look in the url you will see /Datasets/FUID this is your unique identifier. Here is an example highlighted below.

[PMFlorenzano]

Hello @GilbertQ ,

Thank you for your response.  I orginally added the FUID to the definition.pbir file, saved it then attempted to reopen the report in PowerBI Desktop but failed because the pbiServiceModeId was expecting an integer value, not a string like shown below:

{
  "version": "4.0",
  "datasetReference": {
    "byPath": null,
    "byConnection": {
      "connectionString": "Data Source=powerbi://api.powerbi.com/v1.0/myorg/XXXXXXXXXXXXXXXXXXXXXXXXX;Initial Catalog=NNNNNNNNNNNNNNNNNNNNNNNNNNNN;",
      "pbiServiceModelId": "17c4bee02-ac74-4c72-8458-67f4fa7b491e",
      "pbiModelVirtualServerName": "sobe_wowvirtualserver",
      "pbiModelDatabaseName": "NNNNNNNNNNNNNNNNNNNNNNNNNNNN",
      "connectionType": "pbiServiceXmlaStyleLive",
      "name": null
    }
  }
}

Below is the error I receive:
Error while reading '<ccon>C:\NNNNNNNNNNN\NNNNNNNNNNN\PBIP\NNNNNNNNNNNNNNNNNNNNN.Report\definition.pbir</ccon>'. ReportDefinition:

Invalid type. Expected Integer, Null but got String. Path 'datasetReference.byConnection.pbiServiceModelId', line 7, position 66.

[GilbertQ · Accepted solution]

Hi @PMFlorenzano 

What I would suggest is to create a new PBIP file, connecting to a new select model once that is saved definition file and copy and paste that into your existing file?

[PMFlorenzano]

Worked like a charm!  Thank you once again Gilbert!