How to integrate MPBI with source that have refresh tokens?

[Mornagli]

Hello, i need to integrate my MPBI with another source that have api with 'refresh token' that i need to refresh every X minutes.

There is a way i can do it with MPBI? Maybe there is some feature that i can write code in MPBI, and if so, there is option for crone that will run automatically?

Thnak you.

[lbendlin]

Are you planning to have a Direct Query connection?  In Import mode you won't need the refresh token if your data ingestion takes less than the x minutes. 

[Mornagli]

HI @lbendlin, I just need to import data, but my source need to refresh the keys to the API every X time, the refresh is not case of MPBI...

[lbendlin]

Write a pagination script in Power Query that refreshes the token after every x pages.  If you want to brute force it you can refresh your token before each page pull - but I am sure the API endpoint will not be happy about that.

[Mornagli]

@lbendlin thanks for the reply,

Let me explane myself again:
To fetch data from the API i need Key that i have, the problem is that after few houers i need to replace this KEY, I know how to replace the key in PYTHON, If i will make python script that first -> check if the KEY is no longer relevant and replece it and only then fetch the data, Is it possible to write it inside MPBI? And if so, if the data will be on the service, the script will still work?

Thnak you.

[lbendlin]

You are supposed to use proper session authentication when you run your Power BI scripts. You are not supposed to leech off an existing bearer token that you borrowed from an existing session that may expire at will.