Forum Discussion

calsavara's avatar
calsavara
Frequent Visitor
8 years ago

Refresh Now works, but not Scheduled Refresh

Power BI Desktop is able to have the data refreshed just fine. In Power BI Service, the "Refresh Now" function works like a charm as well. However, the "Scheduled Refresh" says that credentials are invalid. Anonymous, Basic and WindowsWithoutImpersonation are not working, although the latter was working just fine until a few days ago. Does anyone have any suggestion on how to fix it?

Need Help

2 Replies

  • v-sihou-msft's avatar
    v-sihou-msft
    Icon for Microsoft Employee rankMicrosoft Employee
    8 years ago

    calsavara

     

    Did you inlucde both cloud source and on-premise source in a single query?

     

    Mashups between a cloud source and an on-premises source, in a single query, will fail to refresh in the personal gateway if one of the sources is using OAuth for authentication. It's known issue. For more details, please see: Troubleshooting Power BI Gateway - Personal

     

    Regards,

    • calsavara's avatar
      calsavara
      Frequent Visitor
      8 years ago
      Thanks for the reply, Simon. This is really strange, since this behavior was found with the Enterprise Gateway, and the whole reason why I’m using the Personal is because it allowed these 2 sources to go together. And this worked for several months, until a few weeks ago. Perhaps a new version killed the only chance we had to make this work? Any fix coming up?