Forum Discussion
save PDQ of report through script
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.
Hi Keen1598,
Based on your description, you need to similar feature in Power BI report, right?
Based on my research, there is no such a function to achieve this requirement. Currently, we can subscrip a report on Power BI services. However, this is a nes feature which release on 2017 Feb, Power BI will email a snapshot of that page to your inbox currently.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-subscribe-to-report/
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideasRegards,
Charlie Liao
1 Reply
v-caliao-msftMicrosoft Employee
Hi Keen1598,
Based on your description, you need to similar feature in Power BI report, right?
Based on my research, there is no such a function to achieve this requirement. Currently, we can subscrip a report on Power BI services. However, this is a nes feature which release on 2017 Feb, Power BI will email a snapshot of that page to your inbox currently.
https://powerbi.microsoft.com/en-us/documentation/powerbi-service-subscribe-to-report/
If you have any concern on this feature, you can submit your idea on the link below. If this feature was mentioned by mulitple users, product team will consider to add this feature to next release.
https://ideas.powerbi.com/forums/265200-power-bi-ideasRegards,
Charlie Liao