Forum Discussion
Enterprise Gateway & DirectQuery Issue
Here are some of the details: I am using an enterised gateway server (running locally on my surface pro 3) I am connecting to a SQL server with a directquery report I am having to restart the...
Using the gateway successfully will rely on having your computer where the gateway is running always on and connected. You're right scheduled refresh sounds like a better option, it is supported with the Enterprise Gateway, make sure to update to the latest.
Make sure you configure the dataset to be import versus Direct Query before publishing your PBIX.