Forum Discussion

BvS's avatar
BvS
Frequent Visitor
3 years ago

Azure Git source control failing on live connection reports

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 p...
Need Help
alihm's avatar
alihm
Icon for Power BI Team rankPower BI Team
3 years ago

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's avatar
    BvS
    Frequent Visitor
    3 years ago

    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