Azure Git source control failing on live connection reports

[BvS]

Hi All

So we have been starting to work with the PBIPS and using azure git as version control on our workspace in sync with the development pipeline.

We have noticed an issue happening with pulling reports that have an live connection and no dataset from the git server towards the development workspace.

As an example we have an development workspace which contains an datamodel, we make an new report and use that datamodel als data source and save it as pbip on the local machine within the local repository. We then git add/commit/push the changes to the azure git server. This al works fine and any other developer can pull the changes. However when we try to pull them towards to development workspace this gives an error. It does show that there are sync differences and shows updates in the source control window. But updating gives the same error and does not work. when we however save the report as pbix and publish to the development workspace and then sync it from there to the git server it all works fine and we can pull the report with the live connection to the local workspace.

Any ideas on whats going on here?

[alihm]

Please open the definition.pbir, go to the connection string, you will find the workspace name.

Please replace the %20 withe normal space.

For example, instead of: "Sales%202023" use "Sales 2023". In general, it should be URL-decoded.

Is it the same connection string Power BI Desktop exported? if yes, I will take it with Power BI Desktop team.

[BvS]

@alihm could you please verify this workspace behavior?

So i checked the PBIR in the azure git server and this does contain the %20 as the workspace name contains spaces, after removing this within the git server the report was able to be pulled to the powerbi workspace without error

However this presented an new issue.

When the report was pulled to the powerbi workspace, it also updated the report there by changing the connection data from By Path: Null and the live connection data, to an local path ..\DATAMODEL.Dataset which makes the report now import the data from datamodel which is in the same local repository and workspace. This action is forced by the workspace and ive tried to undo this but then it just redoes this action. 

Below an screenshot from the git server

[alihm]

To summarize the repo, you use Power BI Desktop create a local report that is connected to a dataset in the web.

Then, you commit and push the report to git.

Then, you go to the dev workspace and update-from-git.

Update fails.

Can you please share the request ID of the failure? I will use it to look into telemetry to debug.

You can find the request ID in the error dialog.

[BvS]

Hi @alihm 

Yes your summary of the way we work is correct, when we pull the update from azure git to the workspace it fails for reports with an live connection (the dataset is in the same workspace).

This is the Request ID ed4af629-2844-b3bd-3505-f1fe639ea7ae

Please let me know if i can do anything to help 🙂

Grt