Power BI Custom Visuals' Community
Welcome to Power BI Custom Visuals Community! Power BI custom visuals is all about community. We are very excited to announce that custom visuals now have a special place in the Power BI community site, to share knowledge, ideas and news! Custom visuals development discussion – Ask questions and share knowledge about developing custom visuals. Custom visuals ideas – Share your ideas, ask for features, propose new custom visuals. Custom visuals community blog – Community news and announcements for new custom visuals available, new APIs released, tips & tricks from developers and users. Power BI custom visuals useful links for developers Developer documents - find here all documents you need Step-by-step tutorial Looking for advanced tutorial? Find it here Visit also our github Find here Power BI visuals' Samples Custom visual's webinar For technichal questions and help please reach out [email protected]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
Displaying same period last month from timestamp column not connected to the date table
I have a model contaning energy measurements on a 15-minute timestamp level, date dimension and time dimension. What I am want to do is displaying the values in this fashion: The page is sliced by month from the date dimension, but the timestamp values on the x-axis here is from the fact table. The problem is that I also want to show last months values on top of this month values. But when I use formulas such as parallelperiod(), dateinperiod(), or dateadd() to get last months values, timestamp values will show for that parallelperiod. Any tricks to manage this? Link to .pbix: https://www.dropbox.com/s/ewh6a027fiuou75/Model.pbix?dl=0 Thanks!
No enough memory to complete this operation when loadin measure into matrix
Hi Everyone, im working on power bi report where i need to multiply "Losses 3 Years Rate" measure values based on Index Year in matrix below is the formula of "Losses 3 Years Rate": Losses 3 Years Rate = IFERROR(DIVIDE( CALCULATE ( [Incurred Claims], FILTER ( ALL( LineReport[Index Year],LineReport[UW Year]), LineReport[Index Year] <= MAX ( LineReport[Index Year]) && LineReport[UW Year] >= MAX(LineReport[UW Year])-2 && LineReport[UW Year] <= MAX(LineReport[UW Year]) ) ) , if( SELECTEDVALUE(LineReport[Index Year])=1, CALCULATE( [Incurred Claims], FILTER ( ALL( LineReport[Index Year],LineReport[UW Year]), LineReport[Index Year] <= MAX ( LineReport[Index Year]) && LineReport[UW Year] >= MAX(LineReport[UW Year])-2 && LineReport[UW Year] <= MAX(LineReport[UW Year]) ) ), CALCULATE ( [Incurred Claims], FILTER ( ALL( LineReport[Index Year],LineReport[UW Year]), LineReport[Index Year] <= MAX ( LineReport[Index Year])-1 && LineReport[UW Year] >= MAX(LineReport[UW Year])-2 && LineReport[UW Year] <= MAX(LineReport[UW Year]) ) ) ),0) it is properly generated as per the below screen shot: now i need to calculate Developement Factor which is the "Losses 3 years Rate" for index year multiply by the others for example: Dev Fac for index 1 = Rate1 * rate2*rate3*rate4*rate5*rate6*rate7*rate8 Dev Fac for index 2 = rate2*rate3*rate4*rate5*rate6*rate7*rate8 Dev Fac for index 3 = rate3*rate4*rate5*rate6*rate7*rate8 Dev Fac for index 4 = rate4*rate5*rate6*rate7*rate8 Dev Fac for index 5 = rate5*rate6*rate7*rate8 Dev Fac for index 6 = rate6*rate7*rate8 Dev Fac for index 7 = rate7*rate8 Dev Fac for index 8 = rate8 Im using the below formula: Cape Cod IL 3 Years Rate = var indexyear = SELECTEDVALUE(LineReport[Index Year]) return EXP( SUMX( FILTER(ALL(LineReport), LineReport[Index Year]<=MAX(LineReport[Index Year]) && LineReport[Index Year]>= indexyear) , LN([Losses 3 Years Rate]) ) ) however the matrix is keep loading and throw a memrory error: below is the formula i used in Matrix Value: Rate Calculation = VAR Val = SWITCH(SELECTEDVALUE('Chain Ladder'[Group]), "Premium 3 Years",[Premium 3 Years Rate], "Premium 5 Years",[Premium 5 Years Rate], "Premium 7 Years",[Premium 7 Years Rate], "Premium All Years",[Premium All Years Rate], "Premium Average",[Premium Average Years Rate], "Losses 3 Years", [Losses 3 Years Rate], "Losses 5 Years",[Losses 5 Years Rate], "Losses 7 Years",[Losses 7 Years Rate], "Losses All Years",[Losses All Years Rate], "Losses Average",[Losses Average Years Rate], "Development Factor",'Cape Cod'[Cape Cod IL 3 Years Rate] ) RETURN FORMAT(Val, "0.00000") appreciate your assistance since i cant go any further with this. Best regards, Georges
