Yeah, thanks Matt. I abandoned the bookmark path - too manual.
EDIT - I've now got it working with Identities and Roles. I can now export a report for every value of a filter.
In case this helps anyone else, here's my simple use case....
I want to create a report for every value of a filter called Country. Because filters aren't yet supported by the ExportTo API, I've used Roles instead.
I created a Role in Power BI Desktop called Country. The filter for this Role is on a table called countries, with a filter expression, [country_code] = username(). The countries table is already setup in my Model with the relevant relationships, and with cross filter direction = single. I then republished my report.
To get the ExportTo working for a specific country, I pass a country code through as the username in the body of the ExportTo API call:
{ "format":"PNG",
"powerBIReportConfiguration":
{ "identities": [
{ "username": "AUS",
"roles": [ "Country"],
"datasets": [ "XXXXXXXXXXXXXXX etc" ]
} ] } }
In my server-side code, all I need to do is call the ExportTo API in a loop, replacing the username in the body of the call with each country code.
