How to work on a report and a semantic model when integrating the workspace in Azure Devops

[AmiraBedh]

I tried to clone the workspace I am working on it using git and I have this folder on my local machine :

The Client Balance report is a report based on a semantic model called ds_collections.

The Client Balance Report.Report contains :

The ds_collections is divided into 2 folders like you see  ds_collections.SemanticModel and ds_collections.Report :

ds_collections.Report :

ds_collections.SemanticModel :

In this case, I have 3 tasks to do :

• Add some visuals to the Client Balance Report
• Add a measure to the semantic model ds_collections
• Do a transformation with Power Query in ds_collections

I can't find any pbip project in the folder to work on it.

What should I do in this case ?

Should I go back to my pbix files that I have and save them as pbip files in my local folder?

I couldn't find any clue on how to work on something already existing.

In some tutos they all start from a pbix file and do the integration later.

Any help and clarification ?

[Anonymous · Accepted solution]

Thank you Jihwan_Kim 

Hi, @AmiraBedh 

You'll need to save as a PBIP file with your PBIX file, and then you'll need to save as a PBIP file with your PBIX file before pushing to a Git workspace in Devops:

Power BI Desktop projects (PBIP) - Power BI | Microsoft Learn

Then follow the following connection to sync your changed PBIP from on-premises to your workspace in Power BI service:

A Complete Guide to Git Integration in Power BI

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[AmiraBedh]

Thank you for your answer it is clear.

But I still want to know if I don't have the pbix or pbip in advance. I mean that I will clone the content of the workspace and later work on it.

[Anonymous]

Hi, @AmiraBedh 

As Super User said, you can open it in vscode and add measures and visuals.

Git integration with Power BI Desktop projects - Power BI | Microsoft Learn

Power BI Desktop project semantic model folder - Power BI | Microsoft Learn

Maybe you should learn about TMSL format. The PBIP file is optional and is used only as a shortcut to the report folder. You can open the report and semantic model for editing in Power BI Desktop by opening the definition.pbir file in the report folder.

Power BI Desktop projects (PBIP) - Power BI | Microsoft Learn

Best Regards

Jianpeng Li

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Jihwan_Kim]

Hi,

I am not sure if I understood your question correctly, but please try to go into the REPORT folder, and then you can see pbir file.

Double click the pbir file, and then you can work on and do all three tasks after you refresh the file.

Thank you.

[AmiraBedh]

So I only work on the pbir file and push my work to the branch I am working on ?

If I want to work with pbip file should I download the content of the workspace and then do the integration from scratch in a seperate workspace?

[Jihwan_Kim]

Hi,

Once the repository is cloned to your local computer, you can open pbir file.

After fixing measure, creating visualizations, and changing something in power query editor are finished, you can save the file, and then stage the changes in VS code -> commit changes.

After Pull Request, and the feature branch is merged to main branch, go to the workspace and you can synchronize the workspace with main branch.
In this situation, generally pbip file is not needed.

Thank you.