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.
