Azure Data Lake
Snapshot in Azure Data Lake (Dynamics 365 / CDS)
Category: Azure Data Lake,CDS,Microsoft Dynamics 365 Author: Nishant Rana Date: 3 days ago Comments: 0

In the previous post, we saw how to export CDS data to Azure Data Lake Gen 2 https://nishantrana.me/2020/09/07/export-data-from-common-data-service-to-azure-data-lake-storage-gen2/ Here let us have a look how the sync and snapshot work. We have already done the configuration and have synced the Account and Contact entity. As the diagram depicts – there is initial sync followed by … Continue reading “Snapshot in Azure Data Lake (Dynamics 365 / CDS)”
Source: Nishant Rana


Deploy and run SSIS package in Azure Data Factory
Category: Azure,Azure Data Factory,Azure Data Lake,Dynamics 365,Microsoft Dynamics 365,SSIS Author: Nishant Rana Date: 2 months ago Comments: 0

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 previous posts, we had created an Azure data factory instance had used Azure SQL Database as the source. Within Azure Data Factory in the Let’s get started … Continue reading “Deploy and run SSIS package in Azure Data Factory”
Source: Nishant Rana


Use Power BI to analyze the CDS data in Azure Data Lake Storage Gen2
Category: Azure Data Lake,Dynamics 365,Microsoft Dynamics 365,Power BI,PowerPlatform Author: Nishant Rana Date: 2 months ago Comments: 0

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 data. Open the Power BI Desktop, and click on Get data Select Azure > Azure Data Lake Gen 2 and click on connect. To get the container … Continue reading “Use Power BI to analyze the CDS data in Azure Data Lake Storage Gen2”
Source: Nishant Rana


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)
Category: Azure Data Lake,Dynamics 365,Microsoft Dynamics 365,Power BI,PowerApps,PowerPlatform Author: Nishant Rana Date: 2 months ago Comments: 0

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 the August 2020 Update of Power BI Desktop. As suggested in the forums, downgrading to June 2020 Update fixed the issue for us. Check out Export CDS data … Continue reading “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)”
Source: Nishant Rana


Error – Access to the resource is forbidden while trying to connect to Azure Data Lake Storage Gen2 using Power BI Desktop
Category: Azure Data Lake,Dynamics 365,Microsoft Dynamics 365,Power BI,PowerPlatform Author: Nishant Rana Date: 2 months ago Comments: 0

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 owner role assigned to the container It turned out we need to assign the Storage Blob Data Reader role to the user. After assigning the role we … Continue reading “Error – Access to the resource is forbidden while trying to connect to Azure Data Lake Storage Gen2 using Power BI Desktop”
Source: Nishant Rana


Export data from Common Data Service to Azure Data Lake Storage Gen2
Category: Azure Data Lake,Dynamics 365,Microsoft Dynamics 365,PowerPlatform Author: Nishant Rana Date: 2 months ago Comments: 0

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 (encryption – data at rest), manageable, scalable, cost-effective, easy to integrate with. Export to Data Lake allows for continuous replication of CDS entities to Data Lake Storage … Continue reading “Export data from Common Data Service to Azure Data Lake Storage Gen2”
Source: Nishant Rana