Install-WindowsFeature Web-Net-Ext failed. Source files could not be found.

Error: Trying to install .NET Framework 3.5 Features on a Windows Server 2016, either through GUI or PowerShell, returns below error (truncated): "The request to add or remove features on the specified server failed. Installation of one or more roles, role services, or features failed. The source files could not be found." Cause: .Net Framework … Continue reading Install-WindowsFeature Web-Net-Ext failed. Source files could not be found.

What and when: DateAdd vs ParallelPeriod vs SamePeriodLastYear

Reza Rad over at http://radacad.com/dateadd-vs-parallelperiod-vs-sameperiodlastyear-dax-time-intelligence-question explains the differences and provides easy usage scenarios for DateAdd, ParallelPeriod and SamePeriodLastYear DAX functions. Read his blog post to see how he reached to below conclusion: DateAdd and SamePeriodLastYear both work based on the DYNAMIC period in the filter context. ParallelPeriod is working STATICALLY based on the interval selected in the … Continue reading What and when: DateAdd vs ParallelPeriod vs SamePeriodLastYear

Power BI: The key didn’t match any rows in the table

Error: Refreshing Power BI report generates "The key didn't match any rows in the table" error. Cause: Click "Edit Queries" button. If you do not see the error message, click "Refresh Preview" button. Once you have the error message, click "Go To Error". Error message will remain, but you should have "Edit Settings" button now, … Continue reading Power BI: The key didn’t match any rows in the table

Expressions that yield variant data-type cannot be used to define calculated columns.

Error: "Expressions that yield variant data-type cannot be used to define calculated columns." Cause: IF based Calculated Columns in Power BI or Power Pivot with 2 different data types is not allowed. Solution: Format one data type as needed using FORMAT() function. FORMAT Function (DAX): https://msdn.microsoft.com/en-us/query-bi/dax/format-function-dax Pre-Defined Numeric Formats for the FORMAT function: https://msdn.microsoft.com/query-bi/dax/pre-defined-numeric-formats-for-the-format-function

How to automatically create and update Visio diagrams from Excel

To successfully create Visio diagrams from Excel, Visio Pro for Office 365 is required. Here you can see the prices or download trial. Open Excel (I have latest release of Excel from Office 365 suite) In the search box, type "process" and hit Enter. Among other search results, 2 Excel templates should appear with Excel … Continue reading How to automatically create and update Visio diagrams from Excel