Forum Discussion
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 ) without doing any changes to the preset slicers (What i saved the report from Pbi Desktop) you get a "full" subscription report , 3 pages with the graphs and data.
If you do a change in the slicers on one page (but leave the rest as default (what i saved the report as from Pbi desktop) i get graphs and data in the pages that are not change , but the change sheet is coming out blank (no lines in the graph).
Have tried to find information about this but cant find any answer.
/Thanks for any help.
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.
8 Replies
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.
Thanks Akash_Varuna
The subscriptions is not for me but for others and they might have diffrent "settings" in the slicers from each other so i am not sure that saving it will work.
Yeah it will take 20-40 sec to excecute the change in the report with slicers (its alot of calculations)
I have the querr set to "no limit" in Pbi desktop, not sure if that is the "increasing query timeouts for better performance".
/ThanksHi Wresen The long slicer execution time (20–40 seconds) likely exceeds Power BI Service's limits. Check the dataset's query timeout settings in the Service. For varying slicer settings, use PDFs or Paginated Reports for consistent results.
Hi Wresen ,
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. If my response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
