We've captured the moments from FabCon & SQLCon that everyone is talking about, and we are bringing them to the community, live and on-demand. Starts on April 14th. Register now
I want to be able to change the Shape Map custom map that is displayed based on the consumer ID. Is it possible to dynamically change a Shape Map custom visual?
For example:
Presuming I have built my own custom topoJSON files for both US and Europe (not using maps built into Shape Maps):
I have customers in the US, and when they log in I need to show them a shape map of just the United States with correlated graphs (not exposing European information). I also have European customers and on their log in I only want to show them a map of Europe with the same correlated graphs (without exposing US information). I cannot manually upload the custom visual each time, and need to automate it on Power BI service. I cannot have the United States and European maps stored on the same topoJSON file due to privacy issues-- they must be separate. I also do not want to make separate reports for each consumer.
Could I maybe point the Shape Map to a URL with topoJSON data? or insert a new topoJSON into the Shape Map upon login each time?
Thanks
Hi @Anonymous
You could configuire dynamical RLS for your dataset:
Create a user table in Power BI, which has columns like: user login account, user region,,ect.
Then create a relationship between user table and your main data table based on the location fields on both tables.
Row-level security (RLS) with Power BI
Dynamic Row Level Security with Power BI Made Simple
Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Thanks for your response Maggie.
I know that RLS can limit my dataset upon login and potentially be used to hide different areas of the map, but if I have data stored in the map itself, I want to be able to upload a different custom visual to ShapeMap based on UserID.
Do you have anything that could help with that potentially? Maybe I misunderstood your response . . .
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.