Search Suggest

EXCEL
EXCEL

Time Animation with ArcGIS Maps in Power BI

(2019-Jan-14)  Dynamic maps with dynamic visualization usually attract my attention, especially when I look at the satellite images of various cloud …

SQL Server data flow into Excel template with Power Query function-based parameter

(2018-July-15)  Your case is to create an Excel template with data extracted from a backend SQL Server database; it takes a few minutes and Power Que…

Get Data experience from Excel to Power BI and SQL Server Analysis Services 2017

(2018-Jan-20) It has been a long journey for the Excel data integration tool Power Query from its early version as an external add-in component in 20…

Power BI Pulse Chart vs. Dancing bars in Excel

[2016-Jun-30]  Recently Microsoft Power BI has been enhanced with a new Pulse Chart custom visualization ( Visual Awesomeness Unlocked: Pulse Chart )…

Analyzing David and Goliath datasets on a same chart; Dual Axis in Excel, Power BI and SSRS

[2016-May-31]  Two different metrics, two different datasets, one may represent a very high value and the other one is very low. What's interesti…

Connecting to Excel (XLSX) in SSIS

Case I cannot access my Excel sheets in SSIS. The Excel version in the Connection Manager is Microsoft Excel 2007 (xlsx). Could not retrieve the tabl…

BUG: Could not decrypt file

Case I have an Excel (xls) file as a source and it has cell protection turned on to prevent editing the wrong cells. It's an official form from a…

Custom SSIS Component: Foreach Excel Worksheet Enumerator

Recently I did a post on how to loop through all sheets in an Excel file. For those who don't like scripting and for those who think the Foreach…

Foreach Excel Worksheet Enumerator

Case I have an Excel file with multiple identical worksheets (one foreach month) and I want to add the data to a single database table. Is there a fo…

Mixed data types in Excel column

Case My column in Excel contains mixed datatypes (strings and numbers). The string values are shown as NULL. How can I get all values? Solution The E…