Publish to Power BI App

[Paullangdell]

Hi power bi community.

I have developed a report using power bi desktop then published to a workspace and then published to an App. The report uses a direct query connection to an azure sql database. My question is do consumers of the app require source data base access (to my azure sql db) to be able to view the visual in the published app? My users all have pro licences, and can access the app but the report visuals error when they select the report. I have one other report in the app based on a import connection and that works fine. Also rather than potentially providing a large number of users with source db access is there a better way to resolve this? Many thanks for any help or advice.

[amitchandak · Accepted solution]

@Paullangdell , The one who publishes it, needs to provide credentials in service. And can share with others.  The viewer of the report does not need credentials of Azure DB, as far as I know.