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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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

Top Solution Authors