How to Create one Item Per Page (one page per customer)

[Anonymous]

Hi,

I have a requirement where i need to create a report where one page per customer-related transactions.

We have more than 2000 customers and one customer have many transactions.

They need one page per customer so i need to create 2000 pages .

Is there anyway i can do the same in Power BI looping through one report for all 2000 customers list

Each page will needs to have customer Id, Customer Name, Address , Sales amount & Items bought and returns etc...

[v-yuaj-msft · Accepted solution]

Hi @Anonymous ,

Do the data in the 2000 pages come from the same dataset? I suggest you can try the "filter" or "slicer" function.

If you only want to create a report with 2000 pages, you can try to use a paginated report.

Please refer to the following link if it is the result you want.

What are paginated reports in Power BI Premium? - Power BI | Microsoft Docs

Hope that's what you were looking for.

Best Regards,

Yuna

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[amitchandak]

@Anonymous , I doubt I have seen such a way. You can see if power BI rest APIs have something to offer to you.

https://docs.microsoft.com/en-us/rest/api/power-bi/

But do need 2000 pages. Or Need RLS to secure a page for each customer?