Power Platform Community Forum Thread Details

Export and e-mail the sliced data from Power BI Table. Ways to get more than 1000 rows when data is sliced.

Hi,

I have a PBI Report in which I have a table contains 100K rows with 8 columns and there are 6 slicers, the Data Set is connected to an Excel file on my system. Now what I am looking for is to create a Power automate flow to email the data present in the table in both situation (Multiple slicer applied or all of the data). However while running my flow, I am getting wrong results as there is a limit of 1000 combination when slicer applied.

Now I am thinking if I keep my master data file on drive or SharePoint and find a way to create a filtered file here only with the same slicer applied in PBI + Row level security rules. May be I can create 6 tables (as I have 6 slicers) in my master data file export the filtered value and append in those 6 table plus take user email id for row level security. And finally filter the data here on drive or SharePoint and share the final filtered file by email.

I think I might need to use two flows, one for getting filter values for PBI and one for filtering and sending email but these two-flow have to work by single click on single button.

So, is it even possible what I am thinking (I am new to power automate)? or is there any easier way to do this? or may be a difficult one but solves this problem? or it's not possible?

Thank you in advance for your efforts.

Quick Links