Forum Discussion

Maricla's avatar
Maricla
Frequent Visitor
2 years ago
Solved

PDF attachment in dynamic subscription filters data only partially

I have set up a dynamic email subscription to a Power BI report of 10 pages, that includes a pdf export of the report. The pdf attachment shows problems in 3 pages and I cannot see anything in the re...
Need Help
  • Maricla's avatar
    Maricla
    2 years ago

    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.

Anonymous's avatar
Anonymous
Not applicable
2 years ago

Hi johnbasha33 ,thanks for the quick reply.

Hi Maricla ,

Regarding your question, you said that the issue only occurs with dynamic subscriptions, and since the issue is specific to dynamic subscriptions, you can refer to the following article to see if there is an issue in the setup, especially the part that defines the mapping between recipients and parameters.

Create a dynamic subscription for a paginated report (Preview) - Power BI | Microsoft Learn

 

Maricla's avatar
Maricla
Frequent Visitor
2 years ago

Thank you.  I have read the equivalent report more specific to Power BI rather than paginated reports:

 

https://powerbi.microsoft.com/en-us/blog/dynamic-subscriptions-are-now-available-for-power-bi-reports/ 

 

as well as this one https://learn.microsoft.com/en-us/power-bi/collaborate-share/power-bi-dynamic-report-subscriptions 

 

What striked me is that data is not shown for the non-relevant sites in the subsription but you still can see their names (and the problem is only on 3 pages out of 10, the other 7 work perfectly).