How to update data source credentials to allow scheduled refresh? (SQL)

[FeedCentralMJ]

My apology if this is a simple question but help would still be appreciated.

I am seeking to schedule the refresh of a Semanic Model in a Workspace. Currently I need to publish from the Desktop every time I want to do a refresh.

When I go to the screen to set up the refresh I get the message that a data source is missing credentials. Where do I go to update these credentials because the Data Source Credentials option on this screen is greyed out?

The data source I am accessing is on an SQL server (in the cloud). I have the credentials to establish the connection from PowerBI Desktop. I just don't know where to update the credentials for refreshing the Workspace in PowerBI Service.

Missing Data Credentials Message

[FeedCentralMJ]

Thanks @collinq,

I think you are probably correct. 

[FeedCentralMJ]

Possible cause/Additional information:

I have been advised that our data source credentials will not work because they are IP restricted. We have been advised not to lift this restriction for data security reasons.

Our server is an Azure Virtual Private Server containing the SQL data source.

Do we need to set up a PowerBI Gateway on this Azure Virtual Private Server?

[collinq · Accepted solution]

Hey @FeedCentralMJ ,

You may have stumbled into a situation where you need a gateway even though the data source is in a cloud.  If you have to have static IP's and have a consistent userid then you can satisfy your security requirements.  You might need to set up secure endpoints - like in this article Private endpoints for secure access to Power BI - Power BI | Microsoft Learn