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.

V-yubandi-msft's avatar
V-yubandi-msft
Community Support
1 year ago

Hi Wresen ,

Regarding query timeout settings in Power BI Service, there isn’t a direct UI option to configure them per report. However, timeouts are influenced by

  1. The data source own timeout settings .
  2. On premises data gateway configurations, if applicable.
  3. Power BI Service limits, including a visual query timeout of 225 seconds.

A few ideas to improve reliability:

Simplify visuals or split the report into smaller pages to reduce load times. If users need different slicer settings consistently, consider.

  1. Paginated Reports, which handle subscriptions and large datasets more efficiently.
  2. Exporting static PDFs, pre filtered as needed for each user.

For more detailed guidance on optimizing DirectQuery performance, you can refer to the official Microsoft documentation: DirectQuery in Power BI - Power BI | Microsoft Learn

 

Regards,

Yugandhar.

 

 

Wresen's avatar
Wresen
Post Patron
1 year ago

Thanks V-yubandi-msft  so much for the explanation.

 

I have located the problem , it seems to be the custom slicer "Attribute slicer" that made it not work.
When i change to the slicers in Pbi desktop it worked as i should.
(now i just need to find a good replacement for Attribute Slicers)

  • V-yubandi-msft's avatar
    V-yubandi-msft
    Community Support
    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.