Showing results for 
Search instead for 
Did you mean: 
New Member

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

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!

Super User
Super User

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.

Helpful resources

May 23 2022 epsiode 5 without aka link.jpg

The Power BI Community Show

Welcome to the Power BI Community Show! Jeroen ter Heerdt talks about the importance of Data Modeling.

charticulator_carousel_with_text (1).png

Charticulator Design Challenge

Put your data visualization and design skills to the test! This exciting challenge is happening now through May 31st!

Power BI Dev Camp Session 22 with aka link 768x460.jpg

Check it out!

Mark your calendars and join us on Thursday, May 26 at 11a PDT for a great session with Ted Pattison!

Power BI Release May 2022 768x460.png

Check it out!

Click here to read more about the May 2022 updates!

Top Solution Authors
Top Kudoed Authors