{"id":101669,"date":"2024-03-06T20:07:16","date_gmt":"2024-03-06T20:07:16","guid":{"rendered":"https:\/\/www.red-gate.com\/simple-talk\/?p=101669"},"modified":"2024-09-03T20:15:16","modified_gmt":"2024-09-03T20:15:16","slug":"reverse-creating-the-pbip-file-from-source-control","status":"publish","type":"post","link":"https:\/\/www.red-gate.com\/simple-talk\/blogs\/reverse-creating-the-pbip-file-from-source-control\/","title":{"rendered":"Reverse Creating the PBIP file from Source Control"},"content":{"rendered":"

On my article about Source Control with GIT, Power BI and Microsoft Fabric<\/a>, I illustrate how to use the PBIP file<\/strong>\u00a0format to include Power BI<\/strong> reports and semantic models in a source control process and stablish a SDLC<\/strong> (Software Development Lifecycle) for Power BI<\/strong>.<\/p>\n

However, the complete explanation is based on saving the development using PBIP format and inserting into source control.<\/p>\n

What happens if we do the opposite?<\/em><\/strong><\/p>\n

Linking a Workspace to the Repository<\/h2>\n

Let’s imagine we already have the report and semantic model published on the Power BI portal. Like on the image below<\/p>\n

\"A<\/p>\n

We link the workspace to a repository, sending the content to the repository.<\/p>\n

\"A<\/p>\n

Finally, we clone the repository to our local machine. Each object in the workspace will have its own folder.<\/p>\n

\"A<\/p>\n

How could we open the report and semantic model again in Power BI Desktop?<\/em><\/strong><\/p>\n

 <\/p>\n

Creating the PBIP File<\/h2>\n

When we start from Power BI and generate the repository, no PBIP file is generated. In this scenario, we need to generate the PBIP ourselves.<\/p>\n

The PBIP structure is very simple. It always points to a report and it’s the report which points to a dataset.<\/p>\n

On our example, a PBIP file for LakehouseLocalDS would be like this:<\/p>\n

<\/p>\n

\n
{\r\n   \"version\"<\/span>: \"1.0\"<\/span>,\r\n   \"artifacts\"<\/span>: [\r\n      {\r\n         \"report\"<\/span>: {\r\n            \"path\"<\/span>: \"LakehouseLocalDS.Report\"<\/span>\r\n         }\r\n      }\r\n   ],\r\n   \"settings\"<\/span>: {\r\n      \"enableAutoRecovery\"<\/span>: true<\/span>\r\n   }\r\n}\r\n<\/pre>\n<\/div>\n
On this example we need 3 PBIP files, but as you may be noticing, they are very simple.<\/p>\n
\"A<\/p>\n
Once we create the PBIPs, we can open them in Power BI Desktop and manage the report and semantic model as usual.<\/p>\n
It’s interesting to notice the \u201c.gitignore\u201d<\/em><\/strong> file is also missing, but once we open a PBIP and save it, even without changing anything, a \u201c.gitignore\u201d file is created.<\/p>\n
We need to push these PBIPs to the repository, so any other developer cloning the repository will have the PBIPs available. The portal will, in fact, ignore these files. It shows the objects based on the folders.<\/p>\n
It’s also important to notice that some changes to the report made on the portal may create an incompatibility with Power BI Desktop. The features on the portal and the features on the desktop version aren’t always aligned.<\/p>\n
Edit on May 3rd, 2024<\/h2>\n
Each report folder contains a PBIR file. Power BI can open a PBIR file directly and it has the same effect as opening a PBIP.<\/p>\n
The PBIP exists as a matter of organization, to help creating a better understanding of the process. However, it’s needless. You can use the PBIR directly, without creating a PBIP.<\/p>\n
In this way, using the process of reverse creating the PBIP is an optional process.<\/p>\n
 <\/p>\n
Additional Reference<\/h2>\n
You may would like to watch the video: Fabric Monday 19: Reverse Create the PBIP<\/a><\/p>\n
Summary<\/h2>\n
If we start the source control from the workspace instead of the local machine, the PBIP file are not created for you. You need to manually create them in a process I call Reverse Creating the PBIP.<\/p>\n
 <\/p>\n","protected":false},"excerpt":{"rendered":"
On my article about Source Control with GIT, Power BI and Microsoft Fabric, I illustrate how to use the PBIP file\u00a0format to include Power BI reports and semantic models in a source control process and stablish a SDLC (Software Development Lifecycle) for Power BI. However, the complete explanation is based on saving the development using……<\/p>\n","protected":false},"author":50808,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_acf_changed":false,"footnotes":""},"categories":[2,159164,159166],"tags":[4963,158997,101611,4179],"coauthors":[6810],"class_list":["post-101669","post","type-post","status-publish","format-standard","hentry","category-blogs","category-microsoft-fabric","category-powerbi","tag-git","tag-microsoft-fabric","tag-power-bi","tag-source-control"],"acf":[],"_links":{"self":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101669","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/users\/50808"}],"replies":[{"embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/comments?post=101669"}],"version-history":[{"count":6,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101669\/revisions"}],"predecessor-version":[{"id":102320,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/posts\/101669\/revisions\/102320"}],"wp:attachment":[{"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/media?parent=101669"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/categories?post=101669"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/tags?post=101669"},{"taxonomy":"author","embeddable":true,"href":"https:\/\/www.red-gate.com\/simple-talk\/wp-json\/wp\/v2\/coauthors?post=101669"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}