Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes! Register now.

Reply
Anonymous
Not applicable

Manage data source credentials in Power Bi Desktop and Power Bi Server

Hi,

I am facing difficulty in updating data source credentials.

 

When I publish my report to power bi server in power bi desktop, I have to give credentials for schedule refresh in the server.

When I download the report and open it in power bi desktop, I have to give again pass credentials for the data source.

 

Can we have workaround for this problem, can we store credentials in power bi report so that we don't have to pass credentials again and again. 

 

Thanks  

1 ACCEPTED SOLUTION
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

 

To your first question, I'm afraid it couldn't achieve in Power BI. This aspect of the design is primarily concerned with data source security. You have no choice but to edit data source credentials  when using gateway to  realize quick and secure data transferring between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.

 

To your second question, I  think your credentials should save automatically . You can go to File | Options and settings | Data source settings and you can edit the credentials there.

5.png

Last , you can come up with a new idea and add your comments there to make some feature coming sooner if you need.

Url: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

If  I misunderstood you question ,please let me know.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
v-easonf-msft
Community Support
Community Support

Hi, @Anonymous 

 

To your first question, I'm afraid it couldn't achieve in Power BI. This aspect of the design is primarily concerned with data source security. You have no choice but to edit data source credentials  when using gateway to  realize quick and secure data transferring between on-premises data (data that isn't in the cloud) and several Microsoft cloud services.

 

To your second question, I  think your credentials should save automatically . You can go to File | Options and settings | Data source settings and you can edit the credentials there.

5.png

Last , you can come up with a new idea and add your comments there to make some feature coming sooner if you need.

Url: https://ideas.powerbi.com/forums/265200-power-bi-ideas

 

If  I misunderstood you question ,please let me know.

 

Best Regards,
Community Support Team _ Eason
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Hi,

I want to enter Datasets's Data Source Credential automatically. As I am importing .PBIX files using Powershell Script. 
Now the issue is, after importing .PBIX file successfully on Power BI Service, the data source should also needed to be entered (username and password). Plz share the solution using Power shell script to enter Data Souce credentials. 
thanks. 

Helpful resources

Announcements
FabCon Global Hackathon Carousel

FabCon Global Hackathon

Join the Fabric FabCon Global Hackathon—running virtually through Nov 3. Open to all skill levels. $10,000 in prizes!

September Power BI Update Carousel

Power BI Monthly Update - September 2025

Check out the September 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.

Top Solution Authors
Top Kudoed Authors