Forum Discussion
PDF attachment in dynamic subscription filters data only partially
I found a workaround to this problem. The measures used for water usage gave zeros (instead of blanks) for the sites that are not in the subscription. Although I think they should be omitted anyway, converting the measure to give blanks instead of zeros, solved the way the report is displayed in the Service. As mentioned, the report in Power BI desktop worked anyway.
Super UserIt sounds like you're encountering issues with dynamic email subscriptions for a Power BI report, specifically with PDF exports of certain pages. Here are some steps you can take to troubleshoot and potentially resolve the problem:
Review Filters and Data Visibility: Double-check the filters applied to the problematic pages in your Power BI report. Ensure that the filters are correctly configured to display only the relevant data for the subscription recipients. Verify that the data visibility settings are consistent across all pages, especially for those pages exhibiting issues.
Check Data Mapping and Visualization: Review the data mapping and visualization settings for the affected pages. Ensure that the data mapping is correctly configured to display the desired information, and that the visualizations render as expected in Power BI Desktop and the Power BI Service. Pay attention to any differences in data mapping or visualization settings between the affected pages and those that are working correctly.
Test Different Export Formats: Experiment with exporting the problematic pages in different formats (e.g., PNG, JPEG, PowerPoint) to see if the issue persists across all export formats or if it's specific to PDF exports. This can help isolate whether the problem lies with the PDF export functionality in Power BI.
Did I answer your question? Mark my post as a solution! Appreciate your Kudos !!