rsDataShapeQueryTranslationError
I'm reaching out because I'm currently facing an issue with a report that works perfectly on both the Local and Dev environments. However, the same copy of the report is not functioning correctly on the UAT and PROD environments, despite the data being identical across all three. The error message I am receiving is as follows: "Error fetching data for this visual. Couldn't retrieve the data for this visual. Please try again later. Please check the technical details for more information. If you contact support, please provide these details. Underlying Error: rsDataShapeQueryTranslationError." To give you some context, I have a measure that connects an import table composite key with a direct table key. If both keys match, I take values from the direct table and display them in the table view. The table has almost 120 columns and numerous rows. Interestingly, when I keep 10 import table columns and 2 direct table columns in the table view, it works fine. However, when I add all the columns, this error occurs. Additionally, I have a button in the report that Action passes a URL (e.g., https:xxx.net/key1, key2, key3, etc.). If the user clicks on the first record from the table, the URL becomes https:xxx.net/key1. Then, if they Ctrl+click on the second record, the URL becomes https:xxx.net/key1, key2, and so on. This works perfectly fine in the Local and Dev servers, but when it comes to UAT and PROD, I immediately get the rsDataShapeQueryTranslationError. Could you please help me understand why this might be happening and how I can resolve this issue? I appreciate any insights or suggestions you may have. Thank you in advance for your assistance. PowerQueryFTW PBI Convert DAX to M Code DAX Measure Query
Need to getting latest date rows only against duplicate dates and unique dates
Hi Team, I need your help to get the desired output in Power BI DAX. Below is my dataset: ProjectName RunId DateTime TotalTest CoveredLine TotalLine Sky 464545 09/19/2024 787 6753 7611 Sky 466518 10/03/2024 787 6753 7611 Sky 468720 10/18/2024 795 6837 7693 Sky 470858 11/05/2024 795 6844 7699 Sky 474794 12/02/2024 808 6933 7790 Sky 475678 12/06/2024 808 6932 7790 Sky 480882 01/16/2025 815 6974 7826 Spark 462901 09/11/2024 1246 0 0 Spark 463000 09/11/2024 1246 34712 52198 Spark 466141 10/01/2024 1246 34719 52254 Spark 467175 10/08/2024 1274 35037 52745 Spark 474420 11/28/2024 1270 35033 52737 Spark 474734 12/02/2024 1270 35033 52737 Spark 481680 01/23/2025 1304 35441 53393 Spark 481763 01/23/2025 1304 35441 53393 Spark 482047 01/24/2025 890 32354 48254 Spark 482154 01/24/2025 1304 35450 53402 Radiance 460937 08/29/2024 65 618 4404 Radiance 461169 08/30/2024 45 232 4404 Radiance 461227 08/30/2024 12 618 1547 Radiance 461229 08/30/2024 65 200 1100 Vision Venture 476179 12/10/2024 78 977 1629 Vision Venture 479004 01/03/2025 84 1242 1629 Vision Venture 479692 01/08/2025 84 1246 1641 I have a projectName filter on my report, and it is set for single selection only. I need to show the latest date data rows only in three different KPIs. See example below: In my dataset, for some projects, I have more than one same date [duplicate dates for last rows] for the month. In this scenario, we should consider only the last rows. For example: If I select the project "Sky," the result should be shown in the KPI against the latest date [01/16/2025]: Total Test: 815 Covered Line: 6974 Total Line: 7826 If I select the project "Spark," there are two entries for the last date [01/24/2025]. In this case, we should consider only the last rows, and the result should be shown in the KPI: Total Test: 1304 Covered Line: 35450 Total Line: 53402 If I select the project "Radiance," there are three entries for the last date [08/30/2024]. In this case, we should consider only the last rows, and the result should be shown in the KPI: Total Test: 65 Covered Line: 200 Total Line: 1100List of values with filter, kindly help me!
Hi Team, Kindly help me for filter visual. I have the 'Data' column and categories columns. like below snapshot format. we required filter, If I select categories col of 'a' then "a" related all data shown like below snapshot. If select 'b' then "b" related of all data required. How to it in DAX with this? Note:- In power query it is possible, by splitting muliple cols and we will do it. but have performacne impact, kindly help me to it using DAX?
identifying active users every month
Hi, I have a list of users every month, and i need to find the active users in every month. maybe by creating a new calculated column which states if the user is active or not - If the user names present in the next available month file then those user names are active or - if a new user appears for the very first time which are not available in any of the month files then they are active from that month onwards. Please note if user names not appearing continuously then they are inactive. please find the data like below: column names are: System user name,Count of System user name,Sum of cost,Monthly Source file Name System user name Count of System user name Sum of cost Monthly Source file Name User_A 3 € 112.50 24-Jan User_A 3 € 112.50 24-Mar User_A 3 € 112.50 24-Apr User_A 3 € 112.50 24-May User_A 3 € 112.50 24-Jun User_A 3 € 112.50 24-Sep User_B 7 € 149.50 24-Mar User_B 7 € 149.50 24-Apr User_B 7 € 149.50 24-May User_B 7 € 149.50 24-Jun User_B 8 € 238.50 24-Sep User_C 5 € 139.50 24-Jan User_C 7 € 151.50 24-Mar User_C 7 € 151.50 24-Apr User_C 7 € 151.50 24-May User_C 7 € 151.50 24-Jun User_C 7 € 151.50 24-Sep User_D 12 € 323.00 24-Jan User_D 13 € 329.00 24-Mar User_D 13 € 329.00 24-Apr User_D 13 € 329.00 24-May User_D 13 € 329.00 24-Jun User_D 14 € 332.00 24-Sep User_E 5 € 138.50 24-Jan User_E 7 € 209.50 24-Mar User_E 7 € 209.50 24-Apr User_E 9 € 222.50 24-May User_E 9 € 222.50 24-Jun User_E 9 € 305.00 24-Sep User_F 11 € 362.50 24-Jan User_F 13 € 374.50 24-Mar User_F 14 € 380.50 24-Apr User_F 14 € 380.50 24-May User_F 14 € 380.50 24-Jun User_F 14 € 463.50 24-Sep User_G 6 € 219.50 24-Apr User_G 7 € 226.00 24-May User_G 6 € 219.50 24-Jun User_G 7 € 246.50 24-Sep User_H 3 € 112.50 24-Mar User_H 3 € 112.50 24-Apr User_H 3 € 112.50 24-May User_H 3 € 112.50 24-Jun User_H 3 € 112.50 24-Sep How do i create this Active users list every month using the above data in power bi?? Thanks in advance for the help
One Slicer Selection Filters Another Slicer Selection
Hello Power BI Community, I have two columns which have their own slicers on the dashboard: AZURE_AUDIT_METRICS[Object] AZURE_AUDIT_METRICS[Segment] When a team member selects a certain Data Object I would like the Segment slicer to filter to a specific Segment automatically. One Object can have many Segments so we want to highlight (filter for) the most important Segment right away. This is best explained with an example.... The user selects Data Object slicer AZURE_AUDIT_METRICS[Object] = "PRA UNIT VENTURE". When this selection is made there are two Segment slicer AZURE_AUDIT_METRICS[Segment] selections available (see screenshot). We want the Segment slicer AZURE_AUDIT_METRICS[Segment] = "UNITVENTURE PUC" to be automatically selected by default when Data Object slicer AZURE_AUDIT_METRICS[Object] = "PRA UNIT VENTURE" is selected. Thank you so much for your assistance!! Brenden
