Difference of R-ggplot graph between PBI-Desktop and PBI-Service

[Anonymous]

Can someone help me with the following issue. In PowerBI Desktop I made an R graph (ggplot).

The size of the graph title is ok, there is a label on the Y-axis and in the gray bars on the right there is some text. When I uploaded the report te PBI-Service the settings of the graph has been changed:

- the size of the graph title is smaller

- there is no label on the Y-axis

- there is no text in the gray bars  on the right.

I don't know what happened. I have a pro-licence, so I think that's not the problem.

I've added the PBI-report: https://www.dropbox.com/s/50vso7n7vomk1un/R-ggplot-graph.pbix?dl=0

thanks!

Paul Bertens

[Anonymous]

Hi @Anonymous,

It has been submit at CRI 75525272 for R script text size related issues.

Regards,
Xiaoxin Sheng

[Anonymous]

 

Hi @v-juanli-msft

I have the same issue as on this post and this post. Can you inform me when the bug is fixed?

Thanks,

Regards,

Paul Bertens

 

[v-juanli-msft · Accepted solution]

Hi @Anonymous

There was a bug fix a little while ago that appears to have unintentionally led to this regression. We already know the fix, we can start right away on getting it deployed, though it may take a little while.

In the meantime if this is causing issues, there is a workaround. You can add the following lines to the beginning of your R script:

if (exists("powerbi_rFontName")){

  library("showtext")

  showtext.opts(dpi = powerbi_rPngDeviceDpi)

  showtext.auto()

}

I created a PBIX with 2 R visuals, 1 without the fix and one with. I’ve pasted below 2 screenshots I took: one of the visuals in PBI Desktop, and another of the same pbix once published to service. Once the fix is deployed, these lines can be removed, but they should not cause any issues if you leave them.

Best Regards

Maggie