The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I have built a dashboard that draws data from an Azure SQL database. Several customers' data is stored in the same SQL. I would like to be able to share this dashboard with customers outside my organization, but I only want them to be able to view their own data, not the data of other customers. I investigate row-level security, but it seems this is incompatible with sharing outside of my organization. I also researched sharing a filtered URL, but by changing the URL, a user granted guest access to the app workspace where the dashboard was created can alter or remove this filter. I suspect a solution may be found by embedding the dashboard in a web app or publishing it as an app - I would prefer not to develop a web app as I am completely unexperienced in this.
What would be the best way to: (1) create a login/password system that alters the query or filters on the dashboard based on who logs in OR (2) create a secure and shareable URL that displays the dashboard filtered to display only one customer's data? It can be assumed that the customer will be a Power BI Pro user, but not a member of my same organization.
Solved! Go to Solution.
Hi @kmccomas23,
I'd liek to suggest you take a look at below link to know how to get Power BI RLS to work with external users:
How to get Power BI RLS to work with external users
Distribute Power BI content to external guest users with Azure AD B2B
Regards,
Xiaoxin Sheng
Hi @kmccomas23,
I'd liek to suggest you take a look at below link to know how to get Power BI RLS to work with external users:
How to get Power BI RLS to work with external users
Distribute Power BI content to external guest users with Azure AD B2B
Regards,
Xiaoxin Sheng
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
55 | |
42 | |
23 | |
23 | |
16 |