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
.NETADO.NETAgileAngularArchitectureASP.NETAuthenticationAzureAzure FunctionBIBig DataBlazorBusinessC#Cloud ServiceCosmosDBCSSDebuggingDesignEncryptionEntity FrameworkFYIGoogleHardwareInternetInterviewsJavascriptjQueryLeadershipLINQManagementMicrosoftMobileMS OfficeMS SQLNetworkingNoSQLOOPProject ManagementSoftware DevelopmentSource ControlSSISSSRSSyncfusionTeamTestingTSQLUncategorizedVendor SoftwareVisual StudioWebWeb ServicesWindowsWordPress
TransactionScope
Makes a code block transactional. Source: https://docs.microsoft.com/en-us/dotnet/api/system.transactions.transactionscope?view=netframework-4.8
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