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

Join us for an expert-led overview of the tools and concepts you'll need to become a Certified Power BI Data Analyst and pass exam PL-300. Register now.

Reply
alydewji
New Member

Connecting Power BI with Filemaker Rest API

Hi.

 

Am new to PowerBI.

 

Have managed to connect powerBI to my filemaker rest API but need to pass the bearer token everytime.  To do so, I need to have postman open, get the bearer token, and that plug that into the query in powerBI so that it fetches data seamless from the filemaker Rest API.

 

Anyone knows how to set it up so that before teh query executes, PowerBI can go and get the bearer token itself, store it in a var, and the pass it onto the actual API call to get data as a bearer token?

 

Any help will 

2 REPLIES 2
charlieups
New Member

Hi,

 

Did you finally made it possible?  I am trying even connect Power BI with the Filemaker API with no success. I can't have the right way to put the url and the header parameters into the web conector.

 

How did you do it? Can you give some guide to how connect them? And you finally solved your problem with the token, any advice will be more than wellcome.

 

Thanks mate!!!!

 

Carlos.

lbendlin
Super User
Super User

Usually your Power Query runs two API calls. The first one to get the token, the second to fetch the data.  Did you see if the Filemaker documentation mentions the expected process?

Helpful resources

Announcements
Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.

June 2025 Power BI Update Carousel

Power BI Monthly Update - June 2025

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

June 2025 community update carousel

Fabric Community Update - June 2025

Find out what's new and trending in the Fabric community.