Solved: RLS (or something similar) in PBI Desktop.

Anonymous · ‎04-27-2019

Happy Saturday!

I work with some colleagues who don't have PBI Pro. I've had them install PBI Desktop (free version). I import D365 entities for reports & I want to send them .pbix files so they can view reports I create for them; I want them to be able to refresh the data from within the PBI Desktop & have the latest D365 info.

Right now, some colleagues can only view certain regions in D365. If I do this with more colleagues in my organization, what is the best way to ensure they only see data in the PBI Desktop for their particular geographical region?

Is there a way to manage this outside of the PBI service?

parry2k · ‎04-27-2019

@Anonymous as per my previous reply, no, there is no way, you have to use powerbi service and user need powerbi pro license.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

View solution in original post

parry2k · ‎04-27-2019

@Anonymous unfortunately you cannot implement RLS in powerbi desktop, you have to share using PowerBI Service for RLS.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎04-27-2019

@parry2k

Thanks for getting back to me.

I read some documentation & watched vids on how you could only add members in the PBI service (i.e., had to be PBI Pro).

I was wondering if there is some way to implement some other flavor of RLS (not RLS in the context of PBI Pro) in the PBI desktop app.

Not sure if there is a way.

parry2k · ‎04-27-2019

@Anonymous as per my previous reply, no, there is no way, you have to use powerbi service and user need powerbi pro license.

Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!

Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo

If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤

Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.

Anonymous · ‎04-28-2019

@parry2k

Thanks for replying & taking the time to read both my posts!

Happy Sunday!

RLS (or something similar) in PBI Desktop.

Helpful resources

Microsoft Fabric Learn Together

Power BI Monthly Update - April 2024

Fabric Community Update - April 2024

How to Get Your Question Answered Quickly