Monday, November 2, 2015

Calculated and Measure columns in PowerBI

Have been generating couple of reports using the calculated columns like the below.












https://www.youtube.com/watch?v=62mLfiNcqVM

Sunday, November 1, 2015

Power BI updates

Generating reports using Power BI is part of my daily activities.
Following link is for the latest updates of Power BI.
http://blogs.msdn.com/b/powerbi/archive/2015/10/20/custom-visualizations-support-and-22-other-features-in-the-power-bi-desktop-october-update.aspx

Thursday, October 22, 2015

Remote desktop connection softwares

We know the TeamViewer to full fill our requirement. Today i got one more software to do similar activities called Ammyy Admin

Monday, October 19, 2015

'advance' is unavailable: call the 'advancedBy(n)' method on the index

'advance' API has been removed in Swift 2.0



Below is some more examples







Solution is in the screenshot and below is the reference
http://stackoverflow.com/questions/32237243/advancedby-api-in-swift-2-0

Saturday, October 10, 2015

Access Is Denied: How to Identify and Fix a Security Role Issue in CRM 2015 Online

Today got following issue

















Log error :
SecLib::AccessCheckEx failed. Returned hr = -2147187962, ObjectID: c27b7472-2210-e511-80fd-c4346bada1fc, OwnerId: 84055570-cf5d-e411-87c7-2c59e5420674,  OwnerIdType: 8 and CallingUser: 3466ec11-9283-e411-9cca-d89d6763df40.

ObjectTypeCode: 1, objectBusinessUnitId: 8765d948-802f-e411-b567-2c59e5420674, AccessRights: AppendToAccess
Resolution:
Give the Bussiness Unit access level at Account entity.
Resources:
http://www.powerobjects.com/2015/02/13/access-denied-identify-fix-security-role-issue/
http://www.consultcrm.co.uk/blog/2011/07/security-roles-microsoft-crm-2011


Sunday, September 6, 2015

Delete a list items using JavaScript library code in SharePoint 2013

Would like to delete 13000+ records from the list in SPO.
SCRIPT  BEGIN
var itemId;
var oListItem;
 $(document).ready(function() {
SP.SOD.executeFunc('sp.js', 'SP.ClientContext', sharePointReady);

    });

function sharePointReady(){
    var clientContext = new SP.ClientContext("XXX");
    var oList = clientContext.get_web().get_lists().getByTitle('Workflow History');
for LOOP
{
    this.oListItem = oList.getItemById(itemId);
    oListItem.deleteObject();

    clientContext.executeQueryAsync(
        Function.createDelegate(this, this.onQuerySucceeded),
        Function.createDelegate(this, this.onQueryFailed)
    );
}
}
SCRIPT END
https://msdn.microsoft.com/en-us/library/office/jj163201.aspx#BasicOps_SPListItemCRUD