Send to PowerBI, using chunk loop. Microsoft Authetication Token Timeout.

Hi

I am trying to load dataset 800k-1mln rows. I am using the “Chunk loop” node to fix issue with "exceeding 1 mln rows limit within 60 minutes. "

My loop has a timer to wait for 60 minutes to continue the load, however I get another error: “Try-Catch block: Error: Access token has expired, resubmit with a new access token, Code: TokenExpired”

Any ideas how to refresh “auto” Microsoft Autheticator token within the loop?

Alternative “manual” scenario is to at least, catch the last row which was loaded to dataset. Start again but c from the point when it finished last time.