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