Forum Discussion
Markzolotoy
4 years agoImpactful Individual
API token
In order to run an Expport to file API I need to get a token which is described here: Getting the correct access token for the resource that you want to access can sometimes be tricky. For Azure S...
DavisBI
4 years agoSolution Specialist
What's your report datasource?
Markzolotoy
4 years agoImpactful Individual
Something like this:
However, actual data will be injected into report via parameters.
- DavisBI4 years agoSolution Specialist
Hi, Markzolotoy Are you need to export the data from paginated report that use SQL Server as data source? You can use Power Automate instead of REST API. First create a connection for SQL Server and config by Data Gateway (need to install first), then use Export Paginated report ( also support parameter)
- Markzolotoy4 years agoImpactful Individual
No, I need to run a report and automatically export it to Excel and get the file back. All of this needs to be excuted from the backend of a web application.