Using SQL Server Management Studio to deploy and run SSIS package in Azure Data Factory
In our previous post, we created the SSIS Catalog (SSISDB) in Azure and deployed the SSIS package using SSDT. Supported version for SSDT – SQL Server Data Tools…
Nishant Rana
1,324
Posts
259,046
Views
Deploy and run SSIS Integration Toolkit for Dynamics 365 on Azure Data Lake (KingswaySoft)
In the previous post, we saw how to deploy and run SSIS packages on the cloud. Here we take it one step further and will deploy and run…
Deploy and run SSIS package in Azure Data Factory
Before the SSIS package can be deployed to Azure Data Factory we need to provision Azure-SQL Server Integration Service (SSIS) runtime (IR) in Azure Data Factory. In the…
D365 CE: Get Logged in User’s Security Roles using JavaScript
Originally posted on Ajit Patra: Many times we come across requirements such as show/hide ribbon buttons based on logged in user’s security role. Earlier, we used to get…
Use Azure Data Factory V2 to load data into Dynamics 365
Let us take a simple example where we will set up an Azure Data Factory instance and use Copy data activity to move data from the Azure SQL…
Failed to get response from server error while trying to connect to Dynamics 365 using linked services – Azure Data Factory
Recently, while trying to connect to Dynamics 365 data set through Linked Service we got the below error Seems like a product issue, so the workaround is Opening…
Use Power BI to analyze the CDS data in Azure Data Lake Storage Gen2
In the previous post, we saw how to export CDS data to Azure Data Lake Storage Gen2. Here we’d see how to write Power BI reports using that…
Error – We don’t support the option ‘HierarchicalNavigation’. Parameter name: HierarchicalNavigation when trying to load table in Power BI Desktop using Azure Data Lake Storage Gen 2 CDM Folder view (beta)
While trying to connect to a table within Azure Data Lake Storage Gen2 through CDS Folder View we got the below error Users have reported this issue with…
Error – Access to the resource is forbidden while trying to connect to Azure Data Lake Storage Gen2 using Power BI Desktop
While trying to connect to Azure Data Lake Storage Gen2 through Power BI Desktop we got the below error Came as surprise cause the user was had the…
Export data from Common Data Service to Azure Data Lake Storage Gen2
Azure Data lake store gen 2 can be described as a large repository of data, structured or unstructured built on top of Azure Blob storage, that is secure…