Forum Discussion
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
| Program | Practice | Provider |
| ALL | ALL | ALL |
| 1 | ALL | ALL |
| 1 | A | ALL |
| 1 | A | 1 |
| 1 | A | 2 |
| 1 | A | 3 |
| 1 | B | ALL |
| 1 | B | 4 |
| 1 | B | 5 |
| 1 | B | 6 |
| 1 | C | ALL |
| 1 | C | 7 |
| 1 | C | 8 |
| 1 | C | 9 |
| 2 | ALL | ALL |
| 2 | A | ALL |
| 2 | A | 1 |
| 2 | A | 2 |
| 2 | A | 3 |
| 2 | B | ALL |
| 2 | B | 4 |
| 2 | B | 5 |
| 2 | B | 6 |
| 2 | C | ALL |
| 2 | C | 7 |
| 2 | C | 8 |
| 2 | C | 9 |
| . | . | . |
| . | . | . |
| . | . | . |
| X | X | X |
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
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
