Forum Discussion
Bearer Token as Parameter/Variable in Power Query M
angeloola , refer if these can help
https://docs.microsoft.com/en-us/power-bi/developer/automation/walkthrough-push-data-get-token
https://www.youtube.com/watch?v=f7HLyiAk-lQ
https://www.youtube.com/watch?v=GPHHdDRSlis
Thanks for the reply, but I can get the token no problem - what I really need is just the syntax to load the parameter value into the Authorization header value in the Advanced Editor. Can you help with that?
- scsi0505 years agoRegular Visitor
angeloola did you ever get this to work? I have the same problem. I have the powerquery returning a token but I want to store that in a variable that can be used by other tables.
- EPetit5 years agoRegular Visitor
Hello, I'm very interested about this subject.
I don't use embed power bi, in query, I am using 2 different acess token about the saas application where the data are stored.
The answer of your question : look this video, I'm sure you'll find the solution of your problem.
https://www.youtube.com/watch?v=2RZkc_qrV1g
And be careful about this: https://docs.microsoft.com/en-us/power-bi/admin/desktop-privacy-levels