Forum Discussion
jonas_s
5 years agoFrequent Visitor
Scheduled refresh from Azure SQL without a gateway - unhelpful error
Hi everyone My question is this: Can I use the "import" method in Power BI Desktop from an Azure SQL server, create a report, publish the report and have the published report refresh without the u...
v-robertq-msft
5 years agoCommunity Support
Hi, jonas_s
Have you solved the problem with the help of Microsoft?
According to your sample picture, I think you can take a look if the dataset has been connected and mapped to a gateway data source. Because the Azure SQL server doesn’t need a gateway but it can support gateway connections. In this case, I suggest you to check if your dataset has connected to a gateway and turn off the gateway connection to check if you can edit credentials for the data source.
Troubleshooting scheduled refresh for Azure SQL Databases in Power BI
Best Regards,
Community Support Team _Robert Qin
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.