Forum Discussion
"Datasource has no credentials" with Azure SQL Datasource
I am struggling to get up and running with PowerBI. I have successfully created a datasource in PowerBI Desktop and published a report and Dashboard. The problem is even though I can refresh the data in the desktop, the report never updates in the browser. When I try to force a datasource refresh in the browser I get "Datasource has no credentials".
When I set up the SQL Database I created a firewall rule for my IP address and enabled the rule for Azure. Is there anyway that I can get a better error message so I can determine if it's the firewall or the credentials?
This is a bummer of a learning curve.
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.
2 Replies
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...
