Following on from my last post on checking whether query folding is taking place in a Power BI/Power Query query, I’ve just stumbled on another way of doing this – by looking at metadata. I blogged about M metadata and Power Query some time ago (you might want to read the post to get some […]

via Another Way To Check Query Folding In Power BI/Power Query M Code — Chris Webb’s BI Blog


1. Database.query() retrives 50K records where as Database.getQueryLocator() retrives 50 million records from Database. 2. Database.query() is used to construct dynamic query instead of using SOQL query where as Database.getQueryLocator() is the return type of start method of a Batch class.

via Difference between Database.query() and Database.getQueryLocator() — Rahul Yadavansh


Create a Custom JSON in apex code Apex is the coding language for Salesforce cloud computing. Salesforce provides a Class ‘JSONGenerator’ using which one can serialize a collection, wrapper class into JSON or can deserialize in reverse. Using this class a Custom JSON can also be written, below is the code snippet for the same: […]

via Custom JSON Object in Salesforce — Sharad Dhalia


Last Fall when Salesforce introduced Einstein, its artificial intelligence initiative, it debuted with some intelligence built into the core CRM tool, but with a promise that it would expand into other products over time. Today it announced it was adding Einstein AI to its Service Cloud customer service platform. The goal is to make life easier […]

via Salesforce adds some artificial intelligence to customer service products — TechCrunch


Back in Spring ’16, Salesforce added a tool for assessing an org’s security – Setup > Security Controls > Health Check. I hadn’t had a reason to use it until recently. Despite having the standard System Administrator profile, I got the following error when trying to use it. Insufficient Privileges You do not have the level […]

via Salesforce Security Health Check — Eric Santiago


Are you aware that you are able to integrate Salesforce CRM with a successful telephone system? DemoEventSink – this module is designed to listen with events and triggers change of interface in the Web SoftPhone in accordance with the event it received. TAPI is brief for Telephony Application Programming Interface and it is a Microsoft […]

via Salesforce CTI Integration And Salesforce Tutorial For Beginners — Inside Sales Tips


Here are a few lessons learned from implementing this use case: Automate the removal of permission sets from a deactivated user. Understand the structure of permission set and permission set assignments. Use process builder to invoke flow. Strengthen your flow from faulting by adding decision elements. Provide descriptions, where provided, in Salesforce. This may be […]

via Automated Cleanup When User Is Deactivated -Remove User from Permission Sets — Jenwlee’s Salesforce Blog


There has been some great activity this past week in the world of Business Intelligence and here are the updates. Power BI – Tachometer Custom Visual As you can see from the image above, there is a new Custom Visual that has been added called the Tachometer. This is a great visual when you want […]

via BI-NSIGHT – Power BI (Tachometer Custom Visual, Azure Active Directory Content Pack, ZynBit using Power BI Embedded) – SQL Server (CTP 1.2 Available) — Gilbert Quevauvilliers – BI blog


Here are some charts/Dashboards that I have been playing with in Power BI, they are based on attack against defence, they are in the early stages of development so they will change and become more meaningful. All teams from 20 leagues Premiership only Simple dashboard Simple dashboard with filters

via Demo charts & Dashboards using Power BI — General Musings about Stats & Football