EugeneChiang.com

Sum of DataTable Column

Power BI: Disable Filter Panel

Disable Filter Panel from displaying on the reports. File -> Options & Settings In report edit, you will now see this panel…

Adding Error Handling and Transaction to Stored Procedure

Error Handling Error Handling with Transaction

Passing Table Type to Stored Procedure

User-Defined Table Types Stored Procedure Code Note: Need to make sure the type type has the right access permissions.

Power BI: Import vs DirectQuery

The differences between selecting Import and DirectQuery are the following: Import – the selected tables and columns are imported into Power BI Desktop. As you create or interact with a visualization, Power BI Desktop uses the imported data. You must refresh the data, which imports the full data set again, to see any changes that occurred to the underlying data since the initial... » read more

Power BI URL Filters

Query string parameter syntax for filtering With parameters, you can filter the report for one or more values, even if those values contain spaces or special characters. The basic syntax is fairly straightforward; start with the report URL, add a question mark, and then add your filter syntax. URL?filter=Table/Field eq ‘value‘ Table and Field names are case-sensitive, value isn’t. Fields that... » read more

Passing In Filters to Embedded Power BI Charts

Customizing your embed experience using URL Settings The ability to create experiences without advanced coding skills, what’s know as low-code, is truly special with this capability. The embed URL supports several input settings that help you customize your user’s experiences. If you’re using the HTML snippet provided, make sure you update the URL in the... » read more

Try Catch with Transaction

Try Catch in SQL with Transaction. Sources: https://docs.microsoft.com/en-us/sql/t-sql/functions/error-message-transact-sql?view=sql-server-2017

Password Protect File

To password protect file, use WinZip encryption.

SQL Server Build Verions

RTM SP1 SP2 SP3 SP4 Most Recent Version ↓SQL Server 2019 15.0.1600.8 (CTP 3.0) ↓SQL Server 2017 14.0.1000.169 14.0.3192.2 (CVE-2019-1068) ↓SQL Server 2016 13.00.1601.5 13.0.4001.0 13.0.5026.0 13.0.5366.0 (CVE-2019-1068) ↓SQL Server 2014 12.00.2000.8 12.0.4100.1 12.0.5000.0 12.0.6024.0 12.0.6293.0 (CVE-2019-1068) ↓SQL Server 2012 11.00.2100.60 11.0.3000.0 11.0.5058.0 11.0.6020.0 11.0.7001.0 11.0.7469.6 (FIX for SP4) ↓SQL Server 2008R2 10.50.1600.1 10.50.2500 10.50.4000 10.50.6000 10.50.6560.0 (KB4057113) ↓SQL Server 2008... » read more