Hi All, This has me a little confused and would love some feedback please.
GOAL: Build a PBIX file which can be filtered for a specific customer and then shared with the customer via a link and will be limited to just their data. Think of a marketing campaign that you want to filter for each customer and them give them access to only their campaign.
- RLS: This would not work with publish to web and the end customer would require a power BI licence. I would like to make it as simple for the end user and i feel this has a number of pitfalls and maintenance.
- Save as a PDF file. This is a last resort as you lose any interactive nature. Note MS is working on interactive reports in Power point.
- Publish to web. This is the preferred option. We all know the warnings on the can re security with publish to web. Here is what i would like to confirm please.
a) If the model includes underlying data e.g customer email addresses but this is not visable in the final link, is the underlying data still safe?
b) If you created a filter which the user was not able to change, is the underlying data safe.
Any other recommendations would be appreciated.