Krishnaraj RajagopalPower BI: “Make changes to this Model” option unavailableWhen you connect to the Power BI dataset, there should be an option in the status bar showing that you are connecting to the Power BI…1 min read·Jun 6, 2023----
Krishnaraj RajagopalMS Access: Update table with subqueries including multiple joinsIn order to update a table with data joined from other tables, use a query with following syntax1 min read·Jun 26, 2021----
Krishnaraj RajagopalPower BI: How to connect with MS Access as data sourceIf you are using the Power BI 64-bit Desktop and connecting to MS Access, install 64-bit database engine from Microsoft link below.1 min read·Jun 26, 2021----
Krishnaraj RajagopalPower BI: Conditional formatting based on field with color valuesAssuming you have a table with a field that has color values as shown in below example, then the color value field can be used to apply…2 min read·May 17, 2021----
Krishnaraj RajagopalPower BI: Difference between ALL and ALLSELECTED in CALCULATEALL will ignore all the filters inside and outside the query1 min read·May 7, 2021----
Krishnaraj RajagopalPower BI: How to convert columns to rows (unpivot or convert wide to narrow) table dataFollow the below instructions to convert columns to rows1 min read·May 7, 2021----
Krishnaraj RajagopalPower BI: Concatenate multiple textsBelow shows how to concatenate multiple texts in DAX in Power BI1 min read·Feb 17, 2021----
Krishnaraj RajagopalPower BI: Setting Blank DateWhen you have condition, where you want set a date field to blank or date depending on the condition, the following formula will work.1 min read·Oct 1, 2020----
Krishnaraj RajagopalPower BI: Data not showing after PublishThe post explains one of the possible cause of an issue where the published Power BI report is blank with no data, while the data shows up…2 min read·Sep 3, 2020----