Forum Discussion
"Datasource has no credentials" with Azure SQL Datasource
When you publish a .PBIX from Power BI Desktop to the Power BI Web service, all credentials get scrubbed out. You need to re-enter the credentials for your data source in the Power BI Web service.
On PowerBI.com, click the three dots next to the data source, select "Schedule Refresh", open up the menu for Data source credentials, and re-enter the username/password for the Azure SQL database.
When you publish a .PBIX from Power BI Desktop to the Power BI Web service, all credentials get scrubbed out. You need to re-enter the credentials for your data source in the Power BI Web service.
On PowerBI.com, click the three dots next to the data source, select "Schedule Refresh", open up the menu for Data source credentials, and re-enter the username/password for the Azure SQL database.
THANKS!
Ok, here's a newbie note to the product team...TELL US you did this! For example, here is how I would update the Success dialog for the Publish Process. Oh, and put somewhere more obvious...I looked at "Schedule" and said, nope I don't want to schedule it. I want to enter credentials. Maybe a dialog like this...