Join us at FabCon Atlanta from March 16 - 20, 2026, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.
Register now!The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more
Hi
I have a website that uses Rest API I would like to get data from. If I manually get a login token its easily set up but the login token only lasts 24 hrs.
What I need to know if a query could be written to use the url to get a token
https://jwis.cloud.jobpac.com.au:9001/GiveMeAToken?Environment=<ENVNAME>&Application=<MYAPP>&version=1.00&value=<3DES>Everything is static except the <3DES> is a TRIPLE DES encrypted user id and password, along with a date/time stamp in the format:
2016-09-05T15:49:00+10:00<username><password>
A response as a JSON is provided as per below
{"data":[{"ErrorMessage": "","Token": " AHT7UZVT1PCLY66US80JVE765"}]}
This token is then used in web calls to populate all the data I need so from here is easy once I get the active token.
Could anyone assist in writing a query or is it not even possible?
Thanks
Hi, @Jas0r
If you still have no idea about your problem, you can open a support ticket with MSFT to seek technical support , usually they will have better suggestions.
Best Regards,
Community Support Team _ Eason
The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!
Check out the November 2025 Power BI update to learn about new features.
| User | Count |
|---|---|
| 59 | |
| 43 | |
| 42 | |
| 23 | |
| 17 |
| User | Count |
|---|---|
| 190 | |
| 122 | |
| 96 | |
| 66 | |
| 47 |