Am new to PowerBI.
Have managed to connect powerBI to my filemaker rest API but need to pass the bearer token everytime. To do so, I need to have postman open, get the bearer token, and that plug that into the query in powerBI so that it fetches data seamless from the filemaker Rest API.
Anyone knows how to set it up so that before teh query executes, PowerBI can go and get the bearer token itself, store it in a var, and the pass it onto the actual API call to get data as a bearer token?
Any help will