Forum Discussion

jonas_s's avatar
jonas_s
Frequent Visitor
5 years ago

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...
Need Help
_sfrost's avatar
_sfrost
Solution Specialist
5 years ago

jonas_s 

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?

  • jonas_s's avatar
    jonas_s
    Frequent Visitor
    5 years ago


    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...

      • jonas_s's avatar
        jonas_s
        Frequent Visitor
        5 years ago

        I did. They asked for some details, which I provided, still waiting for a reply so I posted here. Still waiting.