Forum Discussion

aashton's avatar
aashton
Helper V
4 years ago
Solved

Deploying pbix through Azure pipeline loses data source

We have a continued problem where pbix files deployed through an Azure pipeline lose their datasource.  So, say I have a pbix file connecting to an Azure SQL Database.  I publish this to a Dev workspace.  I then, using our pipeline, deploy this file into a Test and Prod workspace.  However, when I go to open it in Test or Prod, I get nothing but errors and blank visuals, so I will download the file to see what happened, and there is no data sources in the file.  We can't figure out what we are doing wrong??

  • Deployment pipelines push metadata only, you need to refresh the dataset after deployment.

2 Replies

  • otravers's avatar
    otravers
    Community Champion

    Deployment pipelines push metadata only, you need to refresh the dataset after deployment.

  • Anonymous's avatar
    Anonymous
    Not applicable

    Hi aashton ,

     

    The official documentation says this:

    After the deployment is complete, refresh the datasets so that you can use the newly copied content. The dataset refresh is required because data isn't copied from one stage to another. To understand which item properties are copied during the deployment process, and which item properties are not copied, review the item properties copied during deployment section.

     

    For more details, please refer to this:

    Deploying content to an empty stage

     

    Best Regards,
    Gao

    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly -- How to provide sample data