Cannot View Visuals in Power BI Service w/ Direct Query

[cec4461]

I'm connecting w/ a direct query - a very simple select of a few fields just to test the feature out. The visual is available in desktop. After I publish, it's giving the below error:

Something's wrong with one or more fields: [various fields here]

Please try again later or contact support. If you contact support, please provide these details.

• Activity IDf89672b4-75ed-4af7-b864-aef6d463839d
• Request ID3dd59d8b-f1db-6138-f8cb-c198b0ac062b
• Correlation ID6167a41b-1043-68ff-fe2c-4e63a66756ed
• TimeWed Nov 06 2019 11:09:12 GMT-0500 (Eastern Standard Time)
• Service version13.0.11271.222
• Client version1910.4.033
• Cluster URIhttps://wabi-us-east-a-primary-redirect.analysis.windows.net/

If I change the source from direct query to import back to direct query, it works, but the visual doesn't seem to act like a direct query i.e. it doesn't update when the report is refreshed or interacted with. It only updates after the data is refreshed. The only luck I've been having w/ direct query refreshing and not staying static is w/ a query like (select sysdate from dual). 

I personally don't have a gateway set up, but a coworker does. I'm the one editing and publishing the report.

[Anonymous · Accepted solution]

@cec4461  - You will need to set up the dataset to use a gateway.