Introduction: Handling Errors is a best practice in Integration when integrating to keep a track of the Errors that occurred during Integration. The Customized Error Handling is Handy to find quick Errors to understand them and resolve as required. This approach can be extended to any Source or Destination as required. Our Scenario: Integration from SalesForce – NAV. Different Approaches to Error Handling: No. Approach Description Customizations Required Comments 1. Entity Level All errors will be logged in an ‘Error Log’ entity in Salesforce and NAV along with the error description and date & time the error occurred. 1. Custom entity ‘Error Log’ 2. Fields for ‘Error Log’ entity: i. Name [String(100)] ii. From Entity [String(100)] iii. Error Message [Note] iv. Record ID [String(100)] v. Created On Date [DateTime]   For instance, i. Name: Error while creating ‘Customer’ in NAV ii. From Entity: Customer iii. Error Message: The specified Country is not valid iv. Record ID: Cust123 v. Created On Date: 08/07/2018   Example:    2. Field Level If an error occurs for a record during integration, the error description will be stored in a custom field on the record in Salesforce or NAV. A custom field ‘Error Description’ will have to be created on the form of all required entities. Field: Error Description: [Note]   For instance, when you open a Customer ‘Cust123’, Error Description: The specified Country is not valid   Example:

Change in base URLs for Business Central SaaS Tenants. I have noticed the Business Central links for Tenants have changed. For Production the URL in use will be https://businesscentral.dynamics.com/<Tenant ID>/Productionwhereas earlier the URL https://businesscentral.dynamics.com/<Tenant ID>/ For Sandbox the URL in use will be https://businesscentral.dynamics.com/<Tenant ID>/Sandbox whereas earlier the URL was the same as current URLThis changes are mainly to distinguish between the multiple Production Tenants coming up in October with the 2019 Wave 2  Release. For now, both the Old and New Production Tenant URLs are operational.If you login through https://home.dynamics.com/  or through Admin Center it will redirect you through the New URL. I will keep you posted as soon as notice an updates. #msdynbc #msftadvocate #businesscentral #changeinurls #msdyn365bc

Introduction: After a successful Go-Live in Business Central, we somehow need to delete a record from Backend. There is no way of doing this until you write a code to delete the specific record. I also had a word with Microsoft Support Team who recommend taking this approach. Thus I have created a Generic Record Deletion Tool where you have to put your Table Number and Primary Keys to delete the specific record. Record Deletion Tool : https://github.com/olisterr/Data-Deletion-Tool/blob/master/Report%2050199%20DataDeletionReport.al Pre-requisites: Microsoft Dynamics Business Central Books & References: https://forum.mibuso.com/discussion/6922/how-to-setrange-and-find-a-record-with-recordref-datatype Demonstration: NOTE: This tool is available for free without any warranties. Use it at you own risk. 1. Global Search for the Tool: Searching for the Record Deletion Tool 2. Filter records by Table No. and Primary Keys: Filling in the Table No. and Primary Keys 3. During Record Deletion: Shows the Record Deletion Confirmation 4. After Record Deletion: After the Record is Deleted.   Conclusion: This Record Deletion Tool I have added as an extension to Olof Simren’s Data Deletion Toolkit (https://github.com/olisterr/Data-Deletion-Tool). This tool can be used after Post Go-Live to delete a record in Business Central Production Environment. Also, it can help you browse through the Table Data inorder to find a record. Hope this is useful to you. Let me know in comments.

Many of the time while building project/solution we came across the “reference is required to compile this module error”. The reason behind this error is that your module’s reference package is missing the required package. In error itself, the missing module can be rectified as shown for example in following screenshot reference to “SourceDocumentationTypes” is not made. Now you have to add a missing reference to your module as follows: Select Update model Parameters from Dynamics 365 >>Model Management>>Update model Parameter Now select the required model name from the model list and click on Next. Now make sure to select the checkbox in front of a required reference from reference packages (In our case SourceDocumentationTypes reference was not there ) and click on next. Now click on finish. Now after attaching a reference to the package build package/Solution and you have solved your error.

Most of us need this in our workflow conditions to check against – to have today’s date handy and then use them in If conditions in workflows. But, the filter in If conditions in workflows don’t let you dynamically select On or after ‘Today’. And when you want to compare to today’s date on selection of On or After, you are forced to enter a date and not dynamically select Today. To overcome this, here’s what you can do to simply store Today’s Date in all records. Calculated Date and Time field So workaround this, you can simply create a new Date and Time type of Calculated field to store the current date and use it in your workflow conditions or wherever you need it. Make sure the type of the field is Calculated and then, Edit the criteria. Select Now() function to set the value of the field. And the final criteria condition will simply look like the below Once you save and publish all your changes, you’ll see that the field is automatically populated with today’s date. Using in Workflow Conditions Now, you can use the same in the workflow conditions as shown below – and you should be able to use this in your workflow conditions which could look like this Hope this quick workaround comes handy!    

Power BI provides interactive features that allow for easy navigation and filtering of the visual on click. But, we can also set the interaction between the visuals. We can have some of the visuals default to a filter functionality whereas other visuals use the highlight method. Type of Interaction No-way – no interaction between visuals One-way – interaction occurs from one visual to another, but not in the reverse direction Two-way – interaction occurs between one visual and another in both directions How to set the interaction? Go to the Edit Interactions button on the Format tab of the ribbon in Power BI Desktop. Once you click the Edit interactions button, you can now edit the interactions between the different visuals. As we can see for the Day wise Revenue card we disabled the interaction for the Month range filter and for Total Month Revenue we disabled interaction for the Day range filter. As if we select the day from the dropdown filter we can see that there is no change in Total Month Revenue. Hope this helps!

Modern authentication in Exchange Online enables authentication features like multi-factor authentication (MFA). Modern Authentication is by default enabled in Exchange Online and Outlook 2013 or later supports Modern authentication. I got this issue from one of my clients that the users are unable to login to Outlook after they enforce Multi-Factor Authentications for the users and as the users were using Office 2016, I haven’t thought of checking the modern authentication and it is already enabled in Outlook 2013 or later. But then it might be the possibility that somehow, they have disabled it. Of course, they were able to login to Outlook mobile as this will always use modern authentications and it doesn’t depend whether you have disabled modern authentication for Exchange Online. There was a workaround to create an App password to login but then why not modern authentication. So, let’s see how I enabled modern authentication through PowerShell. Connect to Exchange Online PowerShell. Set-ExecutionPolicy RemoteSigned $UserCredential = Get-Credential $Session = New-PSSession -ConfigurationName Microsoft.Exchange -ConnectionUri https://outlook.office365.com/powershell-liveid/ -Credential $UserCredential -Authentication Basic -AllowRedirection Import-PSSession $Session -DisableNameChecking 2. Run the following command to enable Modern Authentication connection to Exchange Online by Outlook 2013 or later clients. Set-OrganizationConfig -OAuth2ClientProfileEnabled $true 3. Some organizations might have the requirement to disable modern authentication connection to Exchange Online by Outlook 2013 or later clients. Run the following command to disable the same. Set-OrganizationConfig -OAuth2ClientProfileEnabled $false 4. To verify that the change was successful. Get-OrganizationConfig | Format-Table Name,OAuth* -Auto I hope the above steps will be able to resolve the issues whenever the user is unable to login to Outlook client with Multi-Factor Authentication.

This blog will explain how to synch Slicer in Power BI desktop. In slicer syncing, all the pages where slicer has been applied will get synchronized. How to apply slicer syncing? Step1: Select “Date Selection” slicer > Open View Menu > Click “Sync slicer”. Step 2: When we click on slicer syncing it will open the setting for the slicer. Based on our requirement we can select the different combinations to apply slicer and it will get synch across all tabs. Hope this helps!

One can make better and faster-informed decisions when they use Microsoft Power BI Integrations. The business data that is there on your systems have a lot of information that can help you to scale up your business. You can unlock its true potential when you use business intelligence software. Microsoft is the leading company when it comes to creating products that help a business to expand beyond leaps and bounds. It is easy to learn and use. But, unfortunately not many people struggle with the software once they install it as they do not know how to use it. For example, removing duplicate in power query might look like a real struggle if you do not know how to do it. In this blog, we are going to see how to remove duplicate from the column using Power Query, as we know that we can directly apply a transformation on the column and then use remove duplicate. But there is situation when remove duplicate does not work. Situation 1:- Consider the following scenario, we have the same GUID but the case is different in that case duplicate will not get removed. Solution:- Power Query is case sensitive language here both abcdefg123  and Abcdefg123 are considered as different. If you are going to do remove duplicates despite their case of letters, then you have to apply a transformation to change them all to one case; either UPPERCASE or lowercase. Situation 2:- In other scenarios sometimes we have data with leading or trailing space is present so changing it to UPPERCASE, you would still have the extra space, which makes the two texts differ. So, to deal with that we have to use Trim Transformation to remove extra space.

Microsoft Power BI Integrations, in a nutshell, is nothing but a Power BI (business intelligence) software that provides a business analytics solution. It helps companies to visualize their data and to share observations and insights across all the departments in the organizations. Management teams can make crucial decisions based on the information that comes from these reports.  Your decision making is going to be a lot better and faster when you use this particular software. In other words, it is going to make the life of every employee better as they can see where they are doing well and where exactly they need to improve. Companies can scale up high using the data.  Here’s everything that you would want to learn about this product In this blog, we are going to see how to set the default value for value in report filter pane in Power BI. Sometimes we came with a requirement to set default values in a day filter to Current Month as default. Since we cannot use DAX in report level filter directly but we can work around this issue in the following way by creating the following DAX Default Filter = IF(MONTH(Calendar[Date])=MONTH(NOW()) && YEAR(Calendar[Date])=YEAR(NOW()),”This Month”,””) You can drag the filter in the report level filter and select the value as “This Month”.