Forum Discussion
Share different reports with different clients
Memorable MemberHi Luciano
So Z's advice to use Row Level Security (RLS) is for when all the users are within the organization - such as you want sales man Jim to see his sales data while not seeing the sales data of sales man Fred. RLS has alot of documentation put up just within the last month and so you would want to search on the topic and get to know how to implement it - if it is appropriate.
From your post however I don't think it is what you seek if you have completely different clients with completely different information. In this case I believe you have 2 directions to go. One direction is to administer your 365 account. This is not so much a Power BI question as it really is all about segmenting user groups in SharePoint. The other direction is to instruct each client to set up their own 365 account - and you be a participant in their account. Log in for 365 is heavily based on email addresses. If there are going to be many users of Client A - and within them you want to segment what data they view - then you would implement RLS. Whether you do this in your 365 account or their 365 account is going to be based on how much you want to administer things and their willingness to deal potentially with alternate log in IDs.
There is a final, and much simpler solution - which is to use the Publish to Web feature of BI. This is really great - but it is not secure. You will find detailed instructions in the guided learning. With this you easily create a link to your Power BI Service. They you can copy/paste that link into an email. Send the email to your client and they are able to work with the report you made them. I use this and like it. But the big caution is that there is no log in controls so anyone that gets that link can use it. With the Power BI publish to web feature you must delete it manually to turn off that link.
I hope you find this helpful.
Memorable MemberI forgot to add: There is a Share option of dashboards in Power BI Service. Unfortunately for me it has not worked. You cannot share to a public email such as Gmail/Hotmail - - but you are suppose to be able to share a dashboard to any private email.
Some others in community report that it works for them, while others like myself report that it does not work. In my case the feature to auto send the email never gets received at the far end - but I have not completed trouble shooting this as to whether it is an email domain management system on my side. In any case one can also use the url manually I believe.
I must admit have not yet explored the difference between this share feature versus the publish-to-web feature.
This might meet your needs with clients as well.