topic Re: October GA version bug? Chart not render when there is a legend in Report Server

October GA version bug? Chart not render when there is a legend

bonosungho — Wed, 01 Nov 2017 23:56:20 GMT

Hi,

We recently upgraded the preview version of PBI server to recent GA but it seems like chart don't render properly when there is a legend.

Is this known bug ?

Re: October GA version bug? Chart not render when there is a legend

nicholaszyu — Thu, 02 Nov 2017 00:16:27 GMT

yes...the new october GA release, adding a legend to any chart type it seems to cause the chart not to render correctly

Re: October GA version bug? Chart not render when there is a legend

mgmeyer — Thu, 02 Nov 2017 00:43:59 GMT

Thanks for reporting the issue, I just tried this with a Pie chart but didn't see any issues. Can you provide some more detailed repro steps so we can repro it on our end. Thanks!

Matt M.

Re: October GA version bug? Chart not render when there is a legend

bonosungho — Thu, 02 Nov 2017 00:46:41 GMT

Could you please try the line chart or bar chart ??

Re: October GA version bug? Chart not render when there is a legend

mgmeyer — Thu, 02 Nov 2017 00:50:06 GMT

Tried both and still not seeing an issue, can you attach a screen shot of what you are seeing? Is it an error or is the visual just blank? Also can you try clearing your browser cache to see if that resolves the issue. Thanks!

Matt M.

Re: October GA version bug? Chart not render when there is a legend

bonosungho — Thu, 02 Nov 2017 01:04:03 GMT

Im using the analysis service as the data source.. but here is the screenshot on PBI desktop but it doesn't render at all when we publish the report to the server. As you can see above, it looks fine without the legend but as soon as I put the legend, the chart doesn't render but you can see in the data point that there is data.

Re: October GA version bug? Chart not render when there is a legend

bonosungho — Thu, 02 Nov 2017 01:05:54 GMT

Here is the version of PBI Desktop Im using.

Version: 2.51.4885.1041 64-bit (October 2017)

Re: October GA version bug? Chart not render when there is a legend

nicholaszyu — Thu, 02 Nov 2017 04:23:37 GMT

just updated to the new october powerbi server and having the same problem, seems to be when sourcing from an ssas cube connection on powerbi server setting a line/bar chart legend causes issues rendering the chart.

Re: October GA version bug? Chart not render when there is a legend

muchinski — Thu, 02 Nov 2017 09:30:27 GMT

Hi bonosungho,

have you tried to clean the cache of you browser? :)

Re: October GA version bug? Chart not render when there is a legend

bonosungho — Thu, 02 Nov 2017 09:33:00 GMT

Hi Yes. But the issue is still there and PBI desktop is having the same issue. The screenshot i posted earlier is from the PBI desktop not from the server.

Re: October GA version bug? Chart not render when there is a legend

MR2017 — Thu, 02 Nov 2017 13:02:22 GMT

We have the same problem with the October GA version. Also no differenciation in the bars or no bar at all when using legends. Happens in all Stacked Bar visuals, except the 100% Stacked bar, which seem to work. Happens both in PBI DesktopRS October version as well as in the PBI Reporting Server, both connected to multidimensional SSAS with DirectQuery.

Tested on two machines, same results.

Re: October GA version bug? Chart not render when there is a legend

mgmeyer — Thu, 02 Nov 2017 15:39:57 GMT

bonosungho nicholaszyu MR2017 can you provide an isolated repro report and private message it to me so we can try to repro this on our end. This sounds a lot like caching issues but if your seeing it in Desktop and the browser it's likely something else. One more quick question, do any of you have the latest Service version of the Desktop installed? If so are you seeing the issue there? Thanks!

Matt M.

Re: October GA version bug? Chart not render when there is a legend

MR2017 — Thu, 02 Nov 2017 16:34:24 GMT

On the first machine (test machine) formerly only the October service version of Desktop (v2.51.4885.701) was installed, then it was uninstalled, then the Power BI Report Server (June 2017 GA [14.0.600.305] + related June RS version of desktop installed. Worked fine w/o any problems.

Today updated to Power BI Report Server (October 2017 version [14.0.600.434]) + related October RS version of PBI desktop (v2.51.4885.1041) => problems occur as described. Also deleted IE cache, no change.

Issue occurs both with existing SSAS DirectQuery reports and SSAS DirectQuery reports that newly have been created from the scratch in the RS desktop version.

>> do any of you have the latest Service version of the Desktop installed? If so are you seeing the issue there?

On the second machine both the RS October (v2.51.4885.1041) and service October (v2.51.4885.701) PBI desktop clients are installed in parallel (is this allowed/recommended? It's possible...).

Both the existing and also new reports work fine w/o any issue in the October 2017 service desktop version as well as in PBI Azure service environment which I guess currently should be October version as well, whereas in the RS desktop version again we have the described issue.

I will check whether we have left a machine which didn't had installed any service desktop version before, means where we can check RS desktop version (only) with a clean installation.

One remark, possibly not relevant: Both machines are relatively restricted regarding internet access due to to corporate policies and a proxy server, here the first machine more than the second. I mention this because the map visual made some problems here because it wanted to connect to the internet both from the RS desktop as well as from the PBIRS server. We had to allow proxy connects for the respective map sites before it was working. Because map uses Bing this somehow makes sense wheras for stacked bars and columns I would not expect any internet need.

It looks a bit like incompatibilities of possibly shared resources / classes etc. between RS and service desktop tools combined with SSAS DirectQuery/Live access .... just a guess ...

Re: October GA version bug? Chart not render when there is a legend

bonosungho — Fri, 03 Nov 2017 02:01:58 GMT

Hi,

Here is my investigation.

I installed the Power BI Desktop for RS in an isolated machine where no Power BI desktop was installed before but Im experiencing the same issue. Cleared cache, and created from brand new pbix file but the issue is still there when using SSAS data source.

I downloaded the Power BI desktop for cloud version but no issue there. The chart renders fine in the service version.

Re: October GA version bug? Chart not render when there is a legend

Anonymous — Tue, 07 Nov 2017 22:20:54 GMT

I am seeing it in the current verion.

-glen

Re: October GA version bug? Chart not render when there is a legend

nicholaszyu — Tue, 07 Nov 2017 22:28:53 GMT

almost seems as if a bug from powerbi september cloud service made its way into the october report server release

http://community.powerbi.com/t5/Issues/Stacked-Column-Charts-Stopped-working-today-in-pre-existing/idi-p/261066

Re: October GA version bug? Chart not render when there is a legend

bonosungho — Wed, 08 Nov 2017 23:49:59 GMT

The issue seems happening when i select the base measure in the cube. Calculated measures render without any issue....

Re: October GA version bug? Chart not render when there is a legend

v-qiuyu-msft — Thu, 09 Nov 2017 02:28:02 GMT

Hi mgmeyer,

I can reproduce this issue, I have attached this video here, maybe it's helpful for you. :)

Best Regards,
Qiuyun Yu

Re: October GA version bug? Chart not render when there is a legend

mgmeyer — Fri, 10 Nov 2017 17:00:24 GMT

v-qiuyu-msft thanks for the video we have a bug on our end and we're looking into.

Re: October GA version bug? Chart not render when there is a legend

MR2017 — Wed, 22 Nov 2017 11:00:56 GMT

Hi, the updated/fixed PBI Report Server version from November 17th

PBI Report Server - Version 14.0.600.437
PBI Desktop RS - Version 2.51.4885.1423 64-bit (Oktober 2017)

fixed the usage-of-legend-doesn't-let-the visual-render problem for us; this works now in all visuals (Stacked Bars/Columns etc).

Unfortunately there seem to be another issue in there now: the MDX cube formatting not is properly interpreted.

In practice our MDX Mio-cube-formatting after each refresh in the PBI report server report is shown sometimes in mio, sometimes in thousand values. The weird thing: It changes randomly with each refresh (pressing the refresh button).

We deleted the IE browser cache on server and client sides, no change.

This doesn't happen in the PBI Desktop RS - Version 2.51.4885.1423, only in the deployed reports in PBI Report Server - Version 14.0.600.437.

The behaviour doesn't appear in the service / cloud PBI (November release), here the cube format is interpreted always correctly.

We use Analysis Services 2016 direct connection.