Forum Discussion
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 SQL, the resource is https://database.windows.net.
- For Dataverse, the resource is the https:// address for your environment. For example, https://contoso.crm.dynamics.com.
My report is using neither of these databases. How do I get a token?
Thanks
6 Replies
What's your report datasource?
Something like this:
However, actual data will be injected into report via parameters.
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)
Hi Markzolotoy ,
I don't seem to understand what you need. If your report is using neither of these databases. then what data source is your report created based on?
Get an embed token can be found in the following video steps.
Get an embed token for your Power BI dashboards and reports - Guy in a Cube
If the problem is still not resolved, please point it out. Looking forward to your reply.
Best Regards,
Henry
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.The data in injected into report using its parameters. It is in JSON format. The report cannot talk to DB directly. There are special algoritms that prepare data in the backend and inject it into reports.
