Others Archives | Cloudfronts - Microsoft Dynamics 365 | Power BI | Azure

Category Archives: Others

How to Trigger Pipeline in ADF?

Introduction: This blog will guide you through how you can schedule your Pipeline in ADF with the help of scheduled trigger. The Time is crucial when you schedule your Pipeline. Go through all the steps to avoid the common mistake which you might make. Step 1: Click on Trigger and select “New/Edit”. Step 2: Click … Continue reading How to Trigger Pipeline in ADF?

Share Story :

SQL Server Delete duplicates record from a table

Posted On February 20, 2020 by Sandip Patel Posted in

In this blog we will learn how to delete duplicates records from a table in SQL Server. Let’s create a sample table for the demo. Step 1: Create temporary table called tmpTable as follows DECLARE @tmpTable TABLE(EmpID INT IDENTITY(1, 1), EName VARCHAR(50)) Step 2: Insert some record into the tmpTable table. INSERT INTO @tmpTable(EName) VALUES … Continue reading SQL Server Delete duplicates record from a table

Share Story :

How to fix Client found response content type of ”, but expected ‘text/xml’

While running Integration map from Salesforce to AX we might encounter blank response received but expected text/xml. In current use case existing user was deactivated and new user was added into salesforce. To fix this kind of issue we can follow below steps: Login to the salesforce environment Go to setup Following screen will open … Continue reading How to fix Client found response content type of ”, but expected ‘text/xml’

Share Story :

How to Capture Error Description and Error Log Date in Script Component in SSIS

Our Scenario: To resolve the Errors that occur due to  componentMetadata130 and to capture the Error Log Date and Error Description while doing custom Error Handling in SSIS use the following steps. Solution: Error Handling at OLEDB Source Block: Step 1: Add a Script Component to catch the Error Description, Error Log Date and Entity. … Continue reading How to Capture Error Description and Error Log Date in Script Component in SSIS

Share Story :

Auto scale the Power BI Embedded capacity using Job Scheduler in Azure

Power BI Embedded is a Microsoft Azure service that is useful for the ISVs and developers to embed visuals, reports and even dashboard into the application. As Power BI Embedded is a PaaS analytics solution which provide Azure based capacity, Power BI embedded charge customers on an hourly basis there are n annual commitment for … Continue reading Auto scale the Power BI Embedded capacity using Job Scheduler in Azure

Share Story :

Multiple Ways to Share a Canvas App in PowerApps

Introduction :- This blog explains multiple options how to share a Canvas Apps in Power Apps. Steps :- Select App and click on Share option, below screenshot for reference   Options of Sharing Published App :- 1.  Specify each User by Name. Enter Username in sharing panel and click Share button App can be shared … Continue reading Multiple Ways to Share a Canvas App in PowerApps

Share Story :

How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

Introduction: Creating a Connection is one of the first Steps during the integration of data. While performing Integration with Dynamics AX or more specifically Dynamics 365 for Finance and Operations create a connection using the following steps. Step 1: Right Click on Connection Managers and click on New Connection Manager. Step 2: Configure your AX … Continue reading How to create Dynamics 365 Finance & Operations (formerly Dynamics AX) connection in SSIS

Share Story :

How to run your SSRS Report for Past “N” Days from the Report run Date

Introduction If have a parameter on our report to see the past “N” days data on our report, we can perform the following steps. Step 1: Add a new Parameter, say “Days” Step 2: Under the Available Values Section, Add a new Value for the Parameter with value as 7 and expression having the following … Continue reading How to run your SSRS Report for Past “N” Days from the Report run Date

Share Story :

Suggest Vendor Payments feature in Payment Journal – NAV/ Business Central

Introduction: In this blog, I will be attempting to highlight on Suggest Vendor Payment functionality in Payment Journals. Pre-requisites: Microsoft Dynamics Business Central Microsoft Dynamics NAV Demonstration: Last Payment Date: This date is the latest date which can be appeared on Vendor Ledger Entries for making the Payment. Entries that have Due Date or Discount … Continue reading Suggest Vendor Payments feature in Payment Journal – NAV/ Business Central

Share Story :

How to create Tabular Model Project

In this blog, we will learn how to create blank Tabular model project. Pre-requisite: Visual Studio with Business Intelligence template. Data source to import data into Tabular model (in our case we are using SQL Server). Analysis Server to deploy Tabular model.   Go to Visual Studio, and create new project, go to Templates > … Continue reading How to create Tabular Model Project

Share Story :

SEARCH :

FOLLOW CLOUDFRONTS BLOG :

Agro-Tech Services Success Stories

Please fill your details to download the file.

By continuing to use the site, you agree to the use of cookies. more information

The cookie settings on this website are set to "allow cookies" to give you the best browsing experience possible. If you continue to use this website without changing your cookie settings or you click "Accept" below then you are consenting to this.

Close