Forum Discussion
salesforce credentials in Power Bi
Hi HarmVanG,
If each user retrieves data by connecting to Salesforce content pack using his/her own Salesforce.com account, the user will pull in the data to which he has access as smoupre's post.
However, if you set up Salesforce reports using your own Salesforce.com credential in Power BI, and share the reports to other users, you will need to use Row Level Security(RLS) to restrict data access for these users.
Thanks,
Lydia Zhang
Hi HarmVanG,
If each user retrieves data by connecting to Salesforce content pack using his/her own Salesforce.com account, the user will pull in the data to which he has access as smoupre's post.
However, if you set up Salesforce reports using your own Salesforce.com credential in Power BI, and share the reports to other users, you will need to use Row Level Security(RLS) to restrict data access for these users.
Thanks,
Lydia Zhang
Hi Anonymous and Greg_Deckler,
Thanks for your quick reactions to my questions, they've given me the answers I was looking for.
Hi HarmVanG
Just curious, were you able to accomplish your goal of embedding your Power BI reports into Salesforce with user security? If yes, would you mind sharing the details of your setup? We are piloting the same type of environment you described in your post, and would very much appreciate any guidence you could provide.
Thank you!
Karen
Hi Karen,
Thanks for asking the question but currently embedding Power BI into Salesforce isn't in the scope of the pilot. When we started the pilot embedding Power BI into Salesforce wasn't supported yet. What I can tell you is how we've set up our reporting process.
Currently our IT/support team creates data models based on Salesforce objects because our Key Users don't have the modeling skills required. These data models are saved as Power BI templates (.Pbit) and then distributed among our Sales Regions via a sharepoint like solution.
Our Business/Key Users at that point can use the .Pbit files to retrieve the data model. At that point they are required to enter their Salesforce credentials to fill the data model with the data they have access to. At that point they can freely create reports and publish them to the Power BI Service workgroups.
There are some remarks to be made about our solution though:
- If an object has over 10 million rows, Power BI cannot handle it.
- Bi Directional (both) Cross Filtering does not work when there are loops in relationships and (our) Salesforce database has several loops. Since this feature is required to have a filter flow from "many to one" you need to carefully plan your data model. There's a white paper that explains how you can deal with this: https://powerbi.microsoft.com/en-us/blog/bidirectional-cross-filtering-whitepaper-2/
- Depending on the diversity of the requested reports this method may be a potential maintenance nightmare in time as it can quickly lead to a larger amount of data models that need to be maintained.
Currently we're still looking for ourselves what the best setup is so embedding Power BI into Salesforce is not something that is on our radar any time soon.
With Kind Regards,
Harm
