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

The Power BI Data Visualization World Championships is back! It's time to submit your entry. Live now!

Reply
KoenV3
Regular Visitor

Use function outcome a variable/parameter

Hi All,

Hope you can help me with the following. For a report I'm fetching data from different endpoints. Each requires me to authenticate use a token. I'm created a function to get the token from an endpoint which works. But i want to use the token as a parameter in the other queries to get the data (using something like "Headers=[Authorization="Bearer "&{token parameter}]] in the query).

I there a way to automatically use the function to populate the parameter? Or is there an other way to work with tokens in the requests? 

 

KoenV3_0-1695649620949.png


Please let me know any suggestions.

1 REPLY 1
lbendlin
Super User
Super User

lbendlin_0-1695741300039.png

Try that last option.

 

Keep in mind that there is a very fine line between Partitions and Expressions. You could equally have a query that acquires the token and stuffs it in a single column single row table. Then reference that value by row {0} and column name.  Same effect as a Parameter.

Helpful resources

Announcements
December 2025 Power BI Update Carousel

Power BI Monthly Update - December 2025

Check out the December 2025 Power BI Holiday Recap!

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.