Dashboard incoporating SQL Direct Query is having issues sharing/showing to audience

[Anonymous]

Hi everyone!

I've been reading around for similar issues and I have been able to pick up bits and pieces. However, nothing has worked so far.

I have a dashboard I am trying to share to team members that incoporates a SQL Direct Query connection to a sql db. Whenever someone views the dashboard/report, an error appears saying "Can't display the visual". I've tried adding a builder's permission (so made targeted viewers as contributor roles) but nothing has changed. On further investigation of the dataset, it is giving out an error that one or more cloud data sources has been deleted and that I needed a gateway connection. I've installed a personal gateaway connection but running into an issue in applying it. Any help would be much appreicated!

[lbendlin]

You're on the right track. If that is an on-premise data source then any Direct Query action initiated by the users needs to go through a gateway.  You may not want to use a personal gateway as that requires your PC to be running at all times.  Better set up a standard/enterprise gateway  (even better, one with multiple cluster members) on VMs in your on-prem cloud.  Then connect your dataset to the gateway.