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

Tag Archives: Excel

Filter Error In Excel While Exporting SSRS Report From D365 CRM To Excel

Posted On October 10, 2018 by Simran Monteiro Posted in Tagged in , , ,

Introduction: Once a User exports a report to Microsoft Excel from a Microsoft Dynamics CRM environment, they may want to further filter the report in Microsoft Excel. Issue: An issue I came across recently was that the report, when exported to Excel, would not allow me to filter in Excel for the first few columns, … Continue reading Filter Error In Excel While Exporting SSRS Report From D365 CRM To Excel

How to split an ‘Address’ column into multiple columns in SSIS

Posted On December 29, 2017 by Simran Monteiro Posted in Tagged in , ,

Introduction: We can split an Address column into multiple columns for Flat Number, Building, Road, City etc. in order to make it easier to process the data. In order to do this, we can use the Derived Column Transformation in SSIS. Steps: In the screenshot below, you can see the Address column has an aggregated … Continue reading How to split an ‘Address’ column into multiple columns in SSIS

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