Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Dynamic Authorization Token from Rest API leads to Formula.Firewall-Error

Hello Everybody   Im trying to connect trough a REST Api to an external Service. The challange ist, that I have to aquire an Access Token which is only valid for 24 hours.   I managed to load th...
Need Help
  • mahoneypat's avatar
    mahoneypat
    5 years ago

    In that case, you could set up a Flow to make the token request daily and write to a file in the cloud (or SP list), and then use that file as a source in your query to harvest the token prior to refresh.  You can make http calls from flow too.  If needed, you could also send your token query results over to flow to trigger it as a JSON packet (but that is trickier).

    Regards,

    Pat

  • Anonymous's avatar
    Anonymous
    Not applicable
    5 years ago

    Hello Pat

     

    Thanks a lot for your response. Managed to open the File (must have had a conflict with my PowerBI version on my Business Computer). 

     

    I do understand that you integrate the Token Request in the Same Query Statement you use to receive the Data. 
    As I will have to obtain about 10 Tables trough the same API to fully build my reporting model, I was looking for a method to store the Token centrally and reuse that respectively. 

    Do I understand your answer correctly that this is not possible in PowerBi?

     

    Best Regards

     

    Philippe