Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Bulk Score Card creation

Hello Everyone, 

 

I've been given the task to create 200+ scorecards in PowerBI.

 

I can create the model, but my question is how to produce individual PDFs for end-user consumption without having to do them one at a time. 

 

In the past, we would do this with Excel by running a loop. Is there simmilar fuctionality somewhere in PBI I'm not aware of? 

 

Thanks, 

 

--Alfonso

Need Help
Tips and Tricks
  • Eric_Zhang's avatar
    Eric_Zhang
    8 years ago
    Anonymous wrote:

    Hello Everyone, 

     

    I've been given the task to create 200+ scorecards in PowerBI.

     

    I can create the model, but my question is how to produce individual PDFs for end-user consumption without having to do them one at a time. 

     

    In the past, we would do this with Excel by running a loop. Is there simmilar fuctionality somewhere in PBI I'm not aware of? 

     

    Thanks, 

     

    --Alfonso

    Anonymous

    What do you mean "produce indivisual PDFs"? Do you mean print your reports to individual PDFs? If so, AFAIK, it is not possible, as it is a manual operation, just click "file->print->print current page".

     

    By the way, for 200 reports and individuals users, I don't exactly know scenario, however maybe you can merge those reports into one and isolate users via Row Level Security.

1 Reply

  • Eric_Zhang's avatar
    Eric_Zhang
    Microsoft Employee
    8 years ago
    Anonymous wrote:

    Hello Everyone, 

     

    I've been given the task to create 200+ scorecards in PowerBI.

     

    I can create the model, but my question is how to produce individual PDFs for end-user consumption without having to do them one at a time. 

     

    In the past, we would do this with Excel by running a loop. Is there simmilar fuctionality somewhere in PBI I'm not aware of? 

     

    Thanks, 

     

    --Alfonso

    Anonymous

    What do you mean "produce indivisual PDFs"? Do you mean print your reports to individual PDFs? If so, AFAIK, it is not possible, as it is a manual operation, just click "file->print->print current page".

     

    By the way, for 200 reports and individuals users, I don't exactly know scenario, however maybe you can merge those reports into one and isolate users via Row Level Security.