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

Join us at FabCon Vienna from September 15-18, 2025, for the ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM. Get registered

Reply
heidik
Frequent Visitor

Set variable from copy data JSON output - correct syntax?

Hi!

 

I'm trying to create a pipeline that reads Power BI REST APIs and I would like to store the token I get in my first call in a variable to use it later in the authorization step for the next API call. But I'm having a hard time understanding what would be the correct syntax to get the value out from the first copy data that is in a JSON format. Any advice of the syntax or a link to documentation/tutorials how it should be build? 🙂 Or am I doing something completely wrong here? 😄 Thanks!

 

heidik_0-1690440877201.png

heidik_1-1690440905916.png

 

 

1 ACCEPTED SOLUTION
GraceGu
Microsoft Employee
Microsoft Employee
2 REPLIES 2
GraceGu
Microsoft Employee
Microsoft Employee

Awesome thank you @GraceGu I found the solution there! I was using a copy data to get the token but in the tutorial it's just a Web call to get the token that then returns working JSON structure that is easy to read to a variable 🙂

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 FBC25 Carousel

Fabric Monthly Update - June 2025

Check out the June 2025 Fabric 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.