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.

[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.

[F_Reh]

Actually the one-line table (behind the SPC graph) was not an aggregation of all months - it was actually only February data coming through!

So in my specific scenario, the problem was that I was using the dedicated template PBIX file for building the Report Server version of the Dashboard (this was containing pre-built slicers). It seems that one of these pre-built slicers apparently got assigned a Date field from my DatesTable Table (before I had hidden the slicer and forgetting it was still impacting the report). In my investigation, I hovered over the SPC graph to determine what fields were filtering on it, which is where I identified that the Date field (from DatesTable Table) was still effecting it. The confusion was because of the actual Date-related field 'TableX'[YYYYMM] required for this SPC graph (for the X-axis). As soon as I unhid the “offending” hidden Slicer (from Selection Pane), and then deleted the Date Field(from DatesTable Table) assigned to it, which resolved the issue and bringing up a beautiful graph "popped up" for all the months (and not simply February only).

[v-tejrama · Accepted solution]

Hi @F_Reh ,

Thank you for providing such a thorough follow-up; it has helped clarify the situation. The issue you encountered was due to a hidden filter still active in the report, rather than a problem with the SPC visual or Report Server migration.

In your Report Server PBIX, the template contained pre-built slicers, including one linked to the DatesTable Date field. Although this slicer was hidden in the selection pane, it continued to apply its filter context, resulting in the SPC visual displaying only February instead of the full range of months needed for the control chart. Since SPC visuals require a continuous time series, restricting the data to a single period can cause the chart to appear blank.

The confusion was understandable, as the X axis used TableX YYYYMM, which is correct for the SPC chart. However, the hidden slicer introduced an additional date filter that affected the expected outcome. Once the slicer was exposed and the DatesTable Date field removed, the visual displayed the complete dataset across all months.

In filter context from a hidden slicer, not an issue with the custom visual, version differences, or Report Server. When working with reused PBIX templates, it is advisable to review the selection pane and filter context if a visual appears blank after migration.

Thank you.

[v-tejrama]

Hi @F_Reh ,

I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank you.

[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...