Showing results for 
Search instead for 
Did you mean: 
Frequent Visitor

Figuring out a way to import data from API which generates session token each time URL is triggered

Hi All, Greetings,


I have a requirement to pull data from a API (JSON format). The API requires a session token each time we try to access. The Web connector throws error when we enter the credentials. So directly using the API link with credentials is not an option.  Is there a way where the session token can be dynamically stored to access the API link in Power BI?


Thanks in Advance

Shazia, @SoumyaVinod 

Community Support
Community Support

Hi @Shazia_Mohammed ,


Could you please share more detailed information about this issue? (e.g. snapshot, error message, configurations...) 

I find some links which are associated with the issue. Please refer to them if they can help you a little.

Call Power BI Rest API with Dynamic Access Token From Power BI Desktop |Power BI Rest API | Part Two...

Solved: Pull data from RESTful API with token authenticati... - Microsoft Power BI Community

How to get data from REST API (JSON) in Power BI? - Microsoft Power BI Community

Solved: Dynamic Authorization Token from Rest API leads to... - Microsoft Power BI Community


Hope that's what you were looking for.

Best Regards,



If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.


Helpful resources

PBI_User Group Leader_768x460.jpg

Manage your user group events

Check out the News & Announcements to learn more.

Welcome Super Users.jpg

Super User Season 2

Congratulations, the new Super User Season 2 for 2021 has started!

Community Connections 768x460.jpg

Community & How To Videos

Check out the new Power Platform Community Connections gallery!