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