Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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.
Solved! Go to 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.
@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.
User | Count |
---|---|
89 | |
73 | |
69 | |
64 | |
56 |
User | Count |
---|---|
98 | |
92 | |
84 | |
74 | |
66 |