Forum Discussion

Wresen's avatar
Wresen
Post Patron
1 year ago
Solved

Direct Query Subscriptions comes out blank

Hi and thx for reading this.   I have a report that uses 2 direct querys. It is 3 sheets (pages). if you do a subscriptions to the report (in the top of the report little to the left of middle ...
Need Help
  • V-yubandi-msft's avatar
    V-yubandi-msft
    1 year ago

    Hi Wresen ,

    1. Use Power BI's built in slicer instead it’s fully supported in both Desktop and Service environments.

    2. If you need the advanced features of the Attribute Slicer, explore AppSource for certified custom visuals with similar capabilities. Certified visuals are tested for reliability, compatibility, and subscription support.

    For further information, please refer to Microsoft's official guidance on subscriptions and visual limitations: FAQs about Troubleshoot subscribing to dashboards and reports - Power BI | Microsoft Learn

     

    Best regards,
    Yugandhar.

Akash_Varuna's avatar
Akash_Varuna
Super User
1 year ago

Hi Wresen  It might be because Power BI subscriptions struggle to capture visuals accurately when slicer changes impact DirectQuery performance or query timing. Ensure the underlying queries are optimized, simplify visuals, and test slicer interactions in Power BI Service. Save the report with the desired slicer settings and republish to align with the subscription. If the issue still exists consider exporting static snapshots or increasing query timeouts for better performance.