Forum Discussion

delish68's avatar
delish68
Frequent Visitor
2 years ago

Power BI Project PBIP - How to Separate Report Measures from Semantic Model Measures

I am using Power BI Projects and I'm having an issue separating Report and Dataset/Semantic Model development.  My semantic model is separate from my reports.  I have multiple reports that point t...
Need Help
erickeu's avatar
erickeu
Icon for Advocate I rankAdvocate I
2 years ago

1) Publish your datasets to powerbi service

2) open a blank report and connect live to that dataset and save the report as .pbip

3) you'll have the url that you need to change the definition.pbir:
example:

{
"version": "1.0",
"datasetReference": {
"byPath": null,
"byConnection": {
"connectionString": "Data Source=powerbi://api.powerbi.com/v1.0/myorg/AAAAAA;Initial Catalog=\"BBBB\";Access Mode=readonly;Integrated Security=ClaimsToken",
"pbiServiceModelId": null,
"pbiModelVirtualServerName": "sobe_wowvirtualserver",
"pbiModelDatabaseName": "XXXXX-xxxxx-xxXxxx-XXXXX",
"name": "EntityDataSource",
"connectionType": "pbiServiceXmlaStyleLive"
}
}
}

example :BBBB
AAAAAA: Production Finance Workspace
BBBB : Sales Datamodel
XXXXX-xxxxx-xxXxxx-XXXXX = Semantic model gui



 

if this helps, please mark it as a solution 🙂

delish68's avatar
delish68
Frequent Visitor
2 years ago

I've done this but the issue is that the Power BI service doesn't support "byConnection" so when you publish or update from the Git integration, the service changes it back to "byPath". The report then shows that it's out of sync with what's in Git and you get stuck in an endless loop of conflicts and/or Git being updated with "byPath" which brings us back to the original problem.