Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago
Solved

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

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?

Need Help
  • Anonymous's avatar
    Anonymous
    6 years ago

    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! 

2 Replies

  • GilbertQ's avatar
    GilbertQ
    Super User
    6 years ago
    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's avatar
      Anonymous
      Not applicable
      6 years ago

      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!