I can't get schedule refresh working. What am I doing wrong?!

[Akahn]

Schedule Refresh is greyed out for my dataset (Azure SQL database) in PowerBI.

It says:

"You cannot schedule refresh for this dataset because it gets data from sources that currently don't support refresh."

Azure SQL databases are on the list of supported datasets. What am I missing?!

[andre]

there is a bug in service that doesn't like certain data types of columns in your sql azure tables.  something to do with date/datetime formats.  you can get details if you search this forum

[Akahn]

Thanks for the reply! Any chance you could link me to that information?

[majort]

i have the same problem. i found the affected table in my dataset but this table has no date/datetime column. So when i remove this table then schedule refresh works.

i am still investigating the problem.

[majort]

I found an issue with nvarchar columns. Converting the columns to varchar worked for me. Really strange, .. 😕 Not sure if there will be some other issues.