Forum Discussion

Akahn's avatar
Akahn
Icon for Advocate IV rankAdvocate IV
11 years ago

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

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?!

 

4 Replies

  • andre's avatar
    andre
    Icon for Memorable Member rankMemorable Member
    11 years ago

    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's avatar
      Akahn
      Icon for Advocate IV rankAdvocate IV
      11 years ago

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

      • majort's avatar
        majort
        New Member
        11 years ago

        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.