EugeneChiang.com

SQL Server Type: money vs smallmoney

Data type Range Storage money -922,337,203,685,477.5808 to 922,337,203,685,477.5807 (-922,337,203,685,477.58to 922,337,203,685,477.58 for Informatica. Informatica only supports two decimals, not four.) 8 bytes smallmoney – 214,748.3648 to 214,748.3647 4 bytes The money and smallmoney data types are accurate to a ten-thousandth of the monetary units that they represent. For Informatica, the money and smallmoney data types are accurate to a one-hundredth of the monetary units... » read more

Power BI: Show Items With No Data

To enable the Show items with no data feature select a visual, then in the Fields well, right-click the field and select Show items with no data from the menu that appears, as shown in the following image: Sources: https://docs.microsoft.com/en-us/power-bi/desktop-show-items-no-data

C# Format Decimal

Mask Format .ToString(“0.00”) X.XX .ToString(“C2”) $X,XXX.XX Source: https://docs.microsoft.com/en-us/dotnet/api/system.decimal.tostring?view=netframework-4.8

TransactionScope

Makes a code block transactional. Source: https://docs.microsoft.com/en-us/dotnet/api/system.transactions.transactionscope?view=netframework-4.8

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