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

    • majort's avatar
      majort
      New Member
      11 years ago

      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.