Forum Discussion
Solved
Unable to setup a refresh schedule
I made a report using PowerBI Desktop that connects to different SQL Azure Databases using "Import" mode. (Import mode because DirectQuery mode is not supported for more than one database). I publish...
Now I am able to schedule refreshes, even without a gateway. The issue was that the credentials to one of my sources was wrong.
To summarize:
1. As everyone mentioned, using multiple sources is not supported in DirectQuery mode and Import mode is the only way.
2. Refresh scheduling DOES work for Import mode as well. No gateway is needed (for SQL Azure databases).
Now I am able to schedule refreshes, even without a gateway. The issue was that the credentials to one of my sources was wrong.
To summarize:
1. As everyone mentioned, using multiple sources is not supported in DirectQuery mode and Import mode is the only way.
2. Refresh scheduling DOES work for Import mode as well. No gateway is needed (for SQL Azure databases).