You’re offline. This is a read only version of the page.
Hi all,
I am new to power automate and have been trying to set up a workflow where I send in an email a specific page in a power BI report with specific value for Store to a specific store. I have succeeded in setting up a flow that sends the page I want to the email address provided. However, the page sent from the report is always for the value of the store parameter set when the power BI report was saved. So for example, if the power BI report is saved on store "Store1" (where I mean that in the dropdown menu for Store in the report, "Store1" is selected), then the report page is exported and sent to the email address only with the relevant info for "Store1". I would like to set it up so that I can set the value of which store information to send within power automate and create a separate workflow there for each different store, instead of having to save many different copies of the power BI report with a different value for Store selected in each.
I have so far tried using the ReportLevelFilters parameter in power automate. As an example, if the power BI report parameter Store is saved at 'Store1', but I want to selected 'Store2' in power automate, I tried the following:
URL?filter=Store/Store name eq 'Store2'
But this does not seem to work correctly, in that I still end up with the page in the powerBI report containing the information for the value of Store saved in the report, not the value that I selected in power automate.
I have also tried (to correct for spaces in the names of the field):
URL?filter=Store/Store_x0x20_name eq 'Store2'
But this doesn't seem to work either.
Does anyone know if there is a way to filter a power BI report for a specific value of a field through power automate in this way? I hope the above question is clear, any help would be greatly appreciated!
Many thanks,
Ben
Share
Report
All responses (
Answers (
632
