Forum Discussion
Scheduled refresh from Azure SQL without a gateway - unhelpful error
Azure SQL definitely doesn't require a gateway. Refer to the below screeshot where it says Gateway Required - No
Power BI data sources - Power BI | Microsoft Docs
So, you should be able to enter the credentials for the source under Data Source Credentials. Once credentials are provides, you will notice that the Schedule Refresh becomes available and you can set it up for auto refresh.
Since you mentioned enter credentials is greyed out, which is not expected, can you attach any screenshot where exactly it's greyed out or if you are seeing any error messages?
Here's the screeenshot. I've read over the link you sent before, which is why I'm so thoroughly confused and annoyed. Been going back and forth with this for weeks...
Then I would suggest you create a support ticket to the Microsoft Support team
I did. They asked for some details, which I provided, still waiting for a reply so I posted here. Still waiting.
Were you able to resolve this issue by contacting MS Support? Having the exact same issue here. Thanks in advance for any help / advice