Power BI Service Report refresh Azure SQL DB - credentials greyed out

[Anonymous]

Hi community! 

Unfortunately I am unable to refresh my dataset (Azure SQL DB), since there are "missing credentials".

The option to add those is greyed out, if I don't isntall a gateway first.
As far as I know I don't need a gateway for Azure SQL DB, and access for Azure apps is enabled in the firewall settings of my db server. 

Also the SQL database is my only data source for that file.

The refresh works fine in the desktop version.
Any idea how to handle this?

[GilbertQ]

Hi there

Could you post a picture of what the database name is you are using?

And did you look to see if you can find the data source credentials under the dataset settings?

[Anonymous · Accepted solution]

You were right, in the meantime I found out, that it was due to the fact that the port was in the database source name, apparently Power BI Service doesn't like that. Once I deleted the port, I published it again and now it works!