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
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??
Power BI embed Reports is not visible , it shows error message, "This Content isnt available,...."
Hello , I am emebding power bi report in outsystem , i can see one report but, again i added one more report which is RLS based that report was not visible, though i am a member of workspace. it throuws error msg " this content isnt availbel,Learn more about Power BI". Can some one help me . Thanks in advance.
