Skip to main content

Salesforce - Microsoft Power BI

This document outlines basic steps to install and configure Power BI with Salesforce.

Usage / Highlights

  • Retrieve User Data from Salesforce
  • Retrieve Reports from Salesforce
  • Read Only Access to Salesforce
  • Connection to Salesforce is made on behalf of User. In other words, Login Session belongs to the User.
  • Power BI utilises Salesforce OAuth security framework to connect to Salesforce
  • Previous version of Power BI used to be Power Query, but not supported for TLS 1.1 or higher, thus could not connect to Salesforce after TLS 1.1 Security upgrade. Find details on Power Query Installation here.


Installation - Power BI Publisher for Excel

Download Link Download Power BI publisher for Excel
Download for Office 64 Bit ( or 32 Bit) as needed.
Close Microsoft Office Application
Double click the installer file named "PowerBIpublisher_[64bit][en-us].msi"

Installation - Power BI Desktop 


Follow the guide as provide on this site - https://powerbi.microsoft.com/en-us/

After Installation is complete, follow below screenshots to connect your Salesforce Account through OAuth.














References


Comments

  1. Really good information to show through this blog. I really appreciate you for all the valuable information that you are providing us through your blog. Power BI Online Training Bangalore

    ReplyDelete
  2. "Thank you for sharing information. Power BI Online Training Power BI Online Course is also providing detail concepts on Power BI with practical examples."

    ReplyDelete
  3. Well explanation with great coding knowledge. This blog gonna helpful to many. I am expecting these kind blogs in future too.
    Power Bi Training in Bangalore

    ReplyDelete
  4. Well Said, you have furnished the right information that will be useful to anyone at all time. Thanks for sharing your Ideas.
    Power Bi training in bangalore
    Power Bi institutes in bangalore



    ReplyDelete
  5. I was taking a gander at some of your posts in this site and I consider this net site is in suggest of reality warning! hold setting taking area... Avast VPN Activation Code

    ReplyDelete
  6. Took me length to door all the explanation, but I actually partook in the article. It ended up being Very respecting me not set in stone to all the analysts here! Its dependably accessible by means of now you can't unmarried-handedly be proficient, however with engaged! Kaspersky Total Security 2019 Keygen

    ReplyDelete

  7. Intriguing test for a weblog. I've been filtering the net for diversion just and showed up re your web site page. impeccable lucid. Thankful to you a ton for sharing your knowledge! it is fortifying to look that specific people anyway supplement an undertaking into adjusting to their locales. I'll be genuine to check affirm inside the works over again unambiguous quickly. Funny Earth Day Quote

    ReplyDelete

Post a Comment

Popular posts from this blog

Product Evaluation - MuleSoft Anypoint Platform one day workshop

People, Business Executives, Enterprise Architects, Solution/System/Application Architects, Tech Leads, Developers,  who are looking for and want to know more about MuleSoft Integration offering which is compared to other key providers like Software AG WebMethods, Oracle SOA Suite, WSO2, Informatica, etc. Recently I attended a one day Workshop on MuleSoft Anypoint platform . The overall goal of this workshop was to evaluate MuleSoft integration technology offering for a mid-size integration environment which is currently supported through Software AG WebMethods and Oracle SOA Suite. So, if you are in process of evaluating MuleSoft Anypoint Platform for your integration needs, this write up will give you a good high level executive summary overview. MuleSoft Product Offering falls under following category of market offering: iPaaS (Integration Platform as a Service) Hybrid Integration On-Premise Integration Platform Internet of Things (#IOT) Integration Mule

Salesforce - Scheduling a Schedule Job

Following are the different ways to schedule a Schedule Job through a script. Run the given code in Execute Anonymous window and then you could see in Setting -> 'Scheduled Job' that your Job is waiting to be executed. Run a Schedule Job NOW Method - 1 ScheduleSalesTargets c = new ScheduleSalesTargets(); c.execute(null); Method - 2  (This one I prefer, whenever I need to run a job) Check the current Time. If it is, let's say 10:39 AM, in your clock, then set the minute to 41. This will schedule the job for 10:41 AM just two minutes from now. But, if you set minute value to 38, then it will schedule to next hour 11:38 AM ScheduleSales c = new ScheduleSales(); String sch = '0 0 * * * ?'; System.schedule('Sales Job Name - 1',  '0 41 * * * ?', c); You could repeat following, so that job keeps running every 5 minutes while you debug and change the Apex code behind the scene. ScheduleSales c = new ScheduleSales(); String sch = &#