Powerbi deployment pipeline

Hi surbhi 

No, you don’t have to reconnect every month. After the first deploy, set the data source credentials once in the Prod workspace (they don’t copy from Dev). Keep your blob path in parameters and use deployment rules so Dev values switch to Prod automatically. Because you’re on private endpoints, make sure Prod uses the correct gateway (Managed VNet or on-prem/VNet). For refresh, either keep a normal schedule or use Power Automate to trigger a refresh when a new CSV lands in the storage. Optional: turn on Incremental Refresh if the file appends data to speed things up.

Hi surbhi , Thank you for reaching out to the Microsoft Community Forum.

rohit1991  is correct, data source credentials do not carry over from Dev to Prod So, you’ll need to set them once in the Prod workspace and the best practices such as using parameters for your blob path, ensuring the correct gateway is configured for private endpoints and handling refresh either through a schedule or with Power Automate when a new file lands are pretty good.

In your specific case though, since both Dev and Prod point to the same blob storage account, you don’t actually need to set up deployment rules for different parameter values because the path stays the same across environments. You can still keep parameters defined for flexibility, but the values won’t change between stages. Practically, all you need to do is configure the credentials in Prod once, make sure the dataset there is using the right gateway and set up either a scheduled refresh or an automated trigger when new files are added to storage.

Thank you rohit1991  for your continuous contributions to the community.