Forum Discussion
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. A...
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!
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?
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?
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!