Scheduled refresh from Azure SQL without a gateway - unhelpful error

[jonas_s]

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 use of a data gateway? If I try this, I get the an error message:
"Scheduled refresh is disabled because at least one data source is missing credentials. To start the refresh again, go to this dataset's settings page and enter credentials for all data sources. Then reactivate scheduled refresh."
This option, enter credentials, is grayed out and disabled for me for this dataset.

I've tried clearing permissions, the report is about 300MB (well under the 1GB limit), the firewall setting is set to allow connections from Azure sources, I can refresh from PBI Desktop.

There is not dedicated server machine to host a data gateway and I really don't see why I should need it for cloud hosted data, hosted my Microsoft...

Any ideas?

[v-robertq-msft]

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.

[_sfrost]

@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]

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

[_sfrost]

@jonas_s 

Then I would suggest you create a support ticket to the Microsoft Support team

Support | Microsoft Power BI

[jonas_s]

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

[AlexRH]

Were you able to resolve this issue by contacting MS Support? Having the exact same issue here. Thanks in advance for any help / advice