Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Set-up data source in power bi report server


In our company we want to set-up a deployment startegy, we have three Power bi report server environment (dev,test,prod) . we just use power bi desktop and  Power BI report server .


We will be using direct query sql server, my question is that we should set-up the  data source each time we change the environment. we use the powershell command Write-RsRestCatalogItem to upload the report.


I was wondering if there is a way that username and password of the sql db will be transmitted when the user publish from power bi desktop to power bi report server. and from the power bi report server to the different environment






Community Support
Community Support

Hi @OPB12 ,


This does not seem very feasible. The configuration information of the credentials is to ensure the security of the connection, especially for sql data sources connected in direct query mode.

If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.

Best Regards,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources


2023 Release Wave 1 Plans

Power BI release plans for 2023 release wave 1 describes all new features releasing from April 2023 through September 2023.

Power BI Summit Carousel 2

Global Power BI Training

Make sure you register today for the Power BI Summit 2023. Don't miss all of the great sessions and speakers!

BizApps LATAM 2023

Business Application LATAM Summit 2023

Join the biggest FREE Business Applications Event in LATAM this February.

Power Platform Bootcamp

Global Power Platform Bootcamp

In this bootcamp we will deep-dive into Microsoft’s Power Platform stack with hands-on sessions and labs, delivered to you by experts and community leaders.