cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Highlighted
cec4461 Visitor
Visitor

Cannot View Visuals in Power BI Service w/ Direct Query

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.

1 ACCEPTED SOLUTION

Accepted Solutions
Super User
Super User

Re: Cannot View Visuals in Power BI Service w/ Direct Query

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

View solution in original post

1 REPLY 1
Super User
Super User

Re: Cannot View Visuals in Power BI Service w/ Direct Query

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

View solution in original post

Helpful resources

Announcements
New Kudos Given Badges Coming

New Kudos Given Badges Coming

We're rolling out new Kudos Given badges. Find out how many Kudos you've given.

Power Platform World Tour

Power Platform World Tour

Find out where you can attend!

Top Solution Authors
Top Kudoed Authors (Last 30 Days)
Users online (3,524)