Automated Inputs and PDF Results as Output (without using Power Automate)

[Shifty1993]

Dear community,

I created a dashboard which allows the user to do several inputs (using a lot of slicers).

When the user made all his inputs he can click on calculate. It will lead him to the Output page with a lot of results (using several visuals but mostly I integrated my measure results in text boxes or cards.)

The dashboard works perfectly fine so far.

The client wants to have the opportunity now where he can make 100x different input-sets (for example in an Excel-Sheet). Power BI or some written algorithm reads these several inputs in and print out each output for each input-set. It is not allowed to use Power Automate for this task.

It would be nice if you guys could give me some ideas how to do it (or how to code it). I do not need a perfectly solution. Just some ideas to start.

Best regards,

Phil

[Anonymous]

Hi @Shifty1993 ,

Please review the following blogs and check if they are what you want.

1. Using API

Export Filtered Dataset From Power BI Report To SQL Server Programmatically Using API And Power BI ...

2. Persistent Filters

Announcing Persistent Filters in the Power BI Service

Best Regards