How to download data with calculations?

Hi,

I would like to connect to data source from another tool, similar to Power BI Dataset to which excel can connect. Is this possible?

Above would be also a solution but a possibility is also to download all the data from the data source via API to excel or csv.

I have one table as a source and ~200 calculations. These calculations depend on set of parameters.

Can I provide the parameter in URL and download all the data?

I apply these paramters through URL when I download dashboard as PDF.

I tried similar approach with query data view but it download only data from last active worksheet.

Can I somehow just download all data with all calculations?

Thanks.