cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Keen1598 Frequent Visitor
Frequent Visitor

Generate Reports Automatically Parsing Through Parameter Values

Hello All,

 

I'm looking for a creative answer to a problem I'm looking to solve. I would like to use PowerBI to design and implement a dashboard report. This report would have multiple parameter levels that are needed to filter the data: Program, Practice, and Provider. My goal is to be able to programmatically generate and save a PDF output of the Dashboard for each possibility of the parameter combinations.

 

ie

ProgramPracticeProvider
ALLALLALL
1ALLALL
1AALL
1A1
1A2
1A3
1BALL
1B4
1B5
1B6
1CALL
1C7
1C8
1C9
2ALLALL
2AALL
2A1
2A2
2A3
2BALL
2B4
2B5
2B6
2CALL
2C7
2C8
2C9
...
...
...
XXX

 

In SSRS, you could use SSIS to essentially iterate through each of the parameter combinations and have a process cube that generates the pdf. I'm looking to replicate that functionality with PowerBI as the aesthetics are tenfold better.

1 REPLY 1
Community Support Team
Community Support Team

Re: Generate Reports Automatically Parsing Through Parameter Values

Hi @Keen1598,

 

>>My goal is to be able to programmatically generate and save a PDF output of the Dashboard for each possibility of the parameter combinations.

Current, Power bi not support your requirement, it not support to export the data to pdf format.

 

BTW, current power bi can export the report to ppt format, perhaps you can try it.(power bi service)
Notice: it not support to generate the parameter list.

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin Sheng
If this post helps, please consider Accept it as the solution to help the other members find it more quickly
Learning resources: Power BI

Helpful resources

Announcements
New Topics Started Badges Coming

New Topics Started Badges Coming

We're releasing new versions of the badge that everyone's talking about. ;) Check your inbox for notifications.

MBAS 2020

Save the new date (and location)!

Our business applications community is growing—so we needed a different venue, resulting in a new date and location. See you there!

Difinity Conference

Difinity Conference

The largest Power BI, Power Platform, and Data conference in New Zealand

Top Solution Authors
Top Kudoed Authors (Last 30 Days)