Refresh Now works, but not Scheduled Refresh

[calsavara]

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?

[v-sihou-msft]

@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]

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?