Forum Discussion
Secheduled Refresh Issue - Cannot Set Credentials for Dataset
Hi, I'm trying to setup a Scheduled Refresh for a dataset (small dataset - about 50MB) in the Power BI Service which points to Azure SQL Data Warehouse. I'm entering the Authentication Mode as "...
I would check your firewall and other settings on your Azure SQL DW. Generally, for things like Azure SQL DB and such, there is a check box to allow other Azure services to connect to it. You have to do this, for example, if trying to connect to an Azure SQL DB from something like Azure ML. I wonder if there is something similar going on here since it would be the Power BI gateway in the Service connecting to your Azure SQL DW.