hi team,
i have created one flow to send power BI report pages as image in mail body to the users based on their RLS dynamically.
for this i have created the following steps.
1. i have created one list of users mails id's on sharepoint. and using get items steps to get those mail id's in my flow.
2. after that i have initialized one variable.
3. after that i have applied apply to each action to create one loop. where input is values from the get items step number "1"
4. inside the apply to each each loop i have used export to file for power BI reports, where i am doing following things,
4.1 i have defined my workspace , report name, then page visual name, and in identities i am using my user mail id's so that when loop runs it should gone through all the mail id's in the list and export the power BI report as PNG according to their RLS access.
5. after that i am composing my output from the previous step which is step no. "4" by using datauri() function.
6. after that i am using append values to string variable to get the image in my variable which i have defind earlier before apply for each step this is i am doing because if i am initializing any variable inside apply for each then it is giving me error i have checked in forum also , so got this solution to initialize variable first then use append values to string variable step inside the apply for each.
7. after that i am taking the output of step number "6 " in my mail body. but i am not getting image.
please check the screen shot.
here is one more thing if i will use append value to string variable action then it will append the images that i don't want
i just want if i have 6 users with different RLS access then my power BI data as image should attach in mail body and should mailed to the users according to there RLS access.
i have done enough RnD but i did not get any solution please help me team!!!.
