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
PowerBI RB, Data not outputting when Running
Good Morning all! I am creating an order acknowledgement for a company and have experienced an issue. I have created a table (the ones with a black box around them) successfully conecting to my datasource, pulling values named Ship2_address1, Ship2_address2, Ship2_name, Ship2_postcode and Ship2_city, as well as Bill2 for the same fields. I have also created a parameter to only output data relative to another field i've referrenced in another table (the one at the bottom of the page). However, when I try to run this document I do not get any data loading for my top two tables, but I do for my bottom one. To my knowledge I have configured them the same way I have as the bottom one. So far, I have tried reconnecting and testing my data source to ensure its correct (which it is), I have remade the table to ensure that the data fields are correct (the fields are correct) and I have removed and re-added the parameter to see if data can be brought out... I also do not have much experience with PowerBI as a whole so I may have just made a small minor mistake on this. If any clarification is needed on this matter please let me know Kind regards and looking forward to any replies, Avery
Dax to exclude min value from power bi report
Hi all, I have one report where I am showing value as processnum and processname.and i am trying to check all processnum under name excluding min value. Dax: Min= Var a=min(table(processnum) Return processnum > a I am getting error when tried for above. Can anyone suggest
Date displaying differently after publication
Hello I have built a visual that uses a slicer. I want the date to be dd mmm yyyy as below, which it is in desktop when I have built the report. For an unknown reason the slicer displays with the day in PBI browser, which is not desirable as it means the user can't actually see the date they are selecting. Does anyone know why this is happening and how I can fix so that it displays the same as in the desktop? Thanks in advance
how to embed power bi report in php application without second authentication
I have a web application that I want to embed reports from my organization's Power BI server, which is on the organization's domain controller. I embedded the report, but it still requires authentication after opening the page containing the report. How can I solve this problem??
how can use measures for comperision in conditional formatting using power bi
I made two measures to find the sales amount for this day and the previous day. Now, I want to make a comparison between the amounts. I want to use an up arrow icon and a down arrow icon to show me which value is higher than the other. I mean like this I tried to use conditional formatting, but it is difficult to add a measure for comparison." what sould i do ?
Add Search capability to a numeric type field with out transforming data
Problem: I need to add a search capability to a userID field, which is of numeric type. However, it seems that search functionality is only possible on text type fields. Constraint: There are restrictions on making changes to the model or transform data step, and there's a live connection set to the data. Attempts So Far: I can't change the data type in the model view or use advanced query because that requires a transform data step. I can't create a calculated column using DAX, as I couldn't find any option to create a new column in the report. I tried creating a measure to extract the userID from other columns, but creating a measure on a non-calculated column is not supported. Does anyone have any suggestions on how to tackle this issue or if any of my observations above are incorrect? Any help would be greatly appreciated. Thanks!
