Forum Discussion
SPC Graph virtually blank when migrated into OnPremises (Remote Server) PBIX
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.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.
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).
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.