Deploying pbix through Azure pipeline loses data source

[aashton]

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??

[v-cgao-msft]

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

[otravers · Accepted solution]

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