Forum Discussion
Looping Power Bi report
Hi , I am a beginner in Power BI and trying to convert a SSRS report to Power BI. Am doing Sales Rep KPI report. My report has 2 slicers. Rep Code and the Account numbers(filtered when rep code ...
Let's assume you have your list of reps in an Excel file on a sharepoint or Onedrive.
In Power Automate you would
- open the excel file
- iterate through the list
- for each list item call the Power BI Report Export with the rep specific filter and the pages you want to export
- wait for the rendering to finish
- take the resulting PDF and store it somewhere or email it to the rep