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…