Power BI is turning 10, and we’re marking the occasion with a special community challenge. Use your creativity to tell a story, uncover trends, or highlight something unexpected.
Get startedJoin 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
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!
Solved! Go to Solution.
Can you check whether this blog Data Pipelines Tutorial: Ingest files into a Lakehouse from a REST API with pagination ft. AVEVA Dat... can help?
Can you check whether this blog Data Pipelines Tutorial: Ingest files into a Lakehouse from a REST API with pagination ft. AVEVA Dat... can help?
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 🙂
This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.
Check out the June 2025 Fabric update to learn about new features.