Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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,
>>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
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
109 | |
95 | |
77 | |
65 | |
53 |
User | Count |
---|---|
144 | |
105 | |
102 | |
89 | |
63 |