Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Markzolotoy
Impactful Individual
Impactful 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.

My report is using neither of these databases. How do I get a token?

 

Thanks

6 REPLIES 6
v-henryk-mstf
Community Support
Community Support

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?

vhenrykmstf_0-1645496255286.png

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

Reports - Get File Of Export To File In Group - REST API (Power BI Power BI REST APIs) | Microsoft D...


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.

DavisBI
Solution Specialist
Solution Specialist

What's your report datasource?

Markzolotoy
Impactful Individual
Impactful Individual

Something like this:

Markzolotoy_0-1645271354267.png

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)

Markzolotoy
Impactful Individual
Impactful 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.

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

Check out the June 2024 Power BI update to learn about new features.

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

Top Solution Authors