Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
PMFlorenzano
Frequent Visitor

Locating the unique identifier for a dataset within PowerBI

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

1 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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

View solution in original post

4 REPLIES 4
GilbertQ
Super User
Super User

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.

 

GilbertQ_0-1713304975450.png

 





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

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.

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?





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!







Power BI Blog

Worked like a charm!  Thank you once again Gilbert!

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

PBI_Carousel_NL_June

Fabric Community Update - June 2024

Get the latest Fabric updates from Build 2024, key Skills Challenge voucher deadlines, top blogs, forum posts, and product ideas.

Top Solution Authors