Forum Discussion

martinobermayr's avatar
martinobermayr
Icon for Helper I rankHelper I
5 years ago

Report-Filter, Dashboard-Filter and Abonements

Hi.   I have a "Products" report that contains 800 products. I would like to send out exactly this report with a filter on 1 product "X" as a subscription. However, if the filter in the report ...
Tips and Tricks
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
5 years ago

There is currently no better way to do that. Here are some random thoughts:

 

- use a central dataset so you only have to worry about the data once (you still have to do the design changes in each report)

- use report URL filters and accept the fact that users can change filters. Don't fight that.

- rethink your need to have subscriptions. Instead, consider using Power Automate to create report extracts (with the filters) and to send emails with the extract as attachment.

martinobermayr's avatar
martinobermayr
Icon for Helper I rankHelper I
5 years ago

Hi lbendlin  and thanks a lot.

I'm trying the solution with Power Automate, but i get the error "Report requested for export is not on dedicated capacity" when i want to do the pdf-export.

 

is it necessary to carry out these steps https://community.powerbi.com/t5/Developer/REST-API-for-Power-BI-Reports-Export-To-File-giving-error/m-p/1050637#M23340?

 

or can I fix the error more simply?

I think that my knowledge is not enough to fix it with the mentioned steps in de url

 

thanks a lot