Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?!
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
Thanks for the reply! Any chance you could link me to that information?
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.
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.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.