SPC Graph virtually blank when migrated into OnPremises (Remote Server) PBIX

[F_Reh]

Good Afternoon,

I am building a new version of a Dashboard in OnPremises Remote Server (PBIX File). It had originally been developed in the previous Desktop version.

I am using the following SPC (Dev) Chart:

Id: PBISPC_DEV

Version: 1.4.4.20

In the previous Desktop version, a graph appears as this:

But when I copy the exact graph into the new PBIX File (OnPremises Remote Server), it comes up virtually as a blank (in spite of all Tables and Measures being migrated over):

Kindly Advise.

[F_Reh]

The Desktop version is using 1.4.2.0 The new version in Onprem RS, whether I use either 1.4.2.0 or 1.7.4.0 the visual shows as blank.

When I go to 'Show as Table', the table is a "crunched up" one-line one, where the Numerator and Denominator are aggregated.

[andrjohns]

If the data in 'show as table' is only a single row, then the issue is with the data model and not visual. The data displayed in 'show as table' is what powerbi is passing to the visual.

You can verify/debug this by passing the same columns to the table visual, and seeing what the aggregations/rows are displaying

[F_Reh]

When I look at the Table in Table View, it visibly has over 200 rows...Its was only when looking in 'show as table' via the Visual itself that one row appears...I am not sure how to "de-summarise" it..If I can do that, then hopefully it will be resolved...

[andrjohns]

Instead of looking at the table in the 'Table View', try adding the same data, numerator, and denominator columns to the table visual:

And seeing how many rows appear (in the report in the remote server, not the desktop report).

[v-tejrama]

Hi @andrjohns ,

Thanks for the explanation, I really appreciate the guidance.
It was very helpful in understanding the issue better.

Thank you.

[F_Reh]

Unfortunately that is exactly the same version as the new PBIX File (OnPremises Remote Server) i.e. PBISPC.1.7.4.0.pbiviz, which is currently showing blank.

[andrjohns]

What data appears if you select the 'show as table' option :

[andrjohns]

Oh in your post you said you were using an old dev version:

[F_Reh]

Cheers...Would the highlighted one below be a suitable substitute ? :

[andrjohns]

Hi @F_Reh , it's this one: SPC Charts for Power BI

[andrjohns]

@F_Reh The developer of the SPC visual here. I'd really strongly recommend updating your reports to use the visual from the AppSource store, instead of the manually-installed DEV version. The AppSource visual is several versions newer, and is officially certified by Microsoft so will be much more stable across these different platforms

[v-tejrama · Accepted solution]

Hi @F_Reh ,

Hi, based on your description and the way Power BI Report Server functions, it appears the issue is likely due to the custom SPC visual not being fully compatible with the Report Server environment. Power BI Report Server uses a different, often older, rendering engine compared to Power BI Desktop, and as noted in Microsoft documentation, not all features and custom visuals are supported. If a visual depends on newer APIs or features unavailable in Report Server, it may render as blank even if the underlying data is correct.

Since the report works in Desktop but not after migration, this suggests a compatibility issue rather than a problem with your data or DAX. I recommend opening the report in Power BI Desktop for Report Server to test further, and if the problem continues, consider using a supported or alternative visual to verify the behavior.

Thank you.

[lbendlin]

May not be supported

Troubleshoot custom visuals in Power BI Desktop for Power BI Report Server - Power BI | Microsoft Le...