User Profile
SteiniJonsson
Frequent Visitor
Joined 6 years ago
User Widgets
Contributions
Order of colors in R visual are wrong when published to service
I have a dataset which among other things defines colors which should be applied to columns in the visual. This works really well in PBI desktop (and R Studio) but when I publish the report to powerbi.com the order of the colors is wrong (the columns get the wrong color). At first it looked like the colors were sorted in alphabetical order but I was unable to reproduce that. Using color names produced the same result as using the hex codes. I have created a small DAX script to create test tables: ColourNames = DataTable ( "FillColour", string, "Value", integer, "xLabel", integer, { { "Red", 50, 1 }, { "Gold", 30, 2 }, { "Red", 10, 3 }, { "Gray", 40, 4 }, { "Red", 20, 5 } } ) ColourHexes = DataTable ( "FillColour", string, "Value", integer, "xLabel", integer, { { "#ff0000", 50, 1 }, { "#ffd700", 30, 2 }, { "#ff0000", 10, 3 }, { "#bebebe", 40, 4 }, { "#ff0000", 20, 5 } } ) The R script for the visual is: library(ggplot2) ggplot( dataset, aes( x = xLabel, y = Value ) ) + geom_col ( fill = dataset$FillColour ) This is what the graph shold look like (and what it looks like in PBI desktop)... but in the service it looks like this. I'm running version 2.102.845.0 64-bit of PBI desktop. Am I doing something wrong here or is this a bug in the service? Regards, SteiniRe: Error with query parameters (from shared datasets) after upgrading to January 2020 PBIRS
In our case the parameter name in the query is the same as the name of the parameter passed to the query (parameter value). After changing the parameter name the report runs without an error. Regards, SteiniError with query parameters (from shared datasets) after upgrading to January 2020 PBIRS
Hi After upgrading to the January 2020 version of Power BI Report Server some of the reports failed with this error. An error has occurred during report processing. (rsProcessingAborted) The execution failed for the shared data set 'DS1'. (rsDataSetExecutionError) The execution failed for the shared data set 'DS2'. (rsDataSetExecutionError) The execution failed for the shared data set 'DS3'. (rsDataSetExecutionError) Query execution failed for dataset 'DS4'. (rsErrorExecutingCommand) Incorrect syntax near 's'. The last line of the error is the interesting one. After doing a trace on the sql server while running the report I found that the query from the ReportData dataset had an additional letter added to the query at the end one of the predicates. This part of the query then looks like: and m.Column1 in (N'Value1',N'Value2's) If only a single parameter value is selected the additional s is not added and the report runs just fine. The parameter values are coming from shared datasets. Has anybody else experienced anything like this and do you have a solution/workaround (other than the obvious, rollback to the previous version of PBIRS)? Best regards, Steini
