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

[Anonymous]

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, @Anonymous 

[v-yuaj-msft]

Hi @Anonymous ,

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 - YouTube

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,

Yuna

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