Forum Discussion
Web API - how secure is the Key if it is placed here?
Hi Anonymous,
I see, hopefully this article https://docs.microsoft.com/de-de/power-bi/whitepaper-powerbi-security will help. The for you relevant part starts at https://docs.microsoft.com/de-de/power-bi/whitepaper-powerbi-security#data-at-rest.
Hi Anonymous,
if you want to save a token in a secure form, use the Web data connector in PowerQuery and set the Web API key. It will be stored in your User Profile. If you send this PBIX file to somebody else, they have to set the token again.
It is well described in the following article: https://blog.crossjoin.co.uk/2014/03/26/working-with-web-services-in-power-query/
Here is the quote in the blog:
"After this the API token gets stored separately from the query in the secure credentials store and you don’t need to enter it again each time the query runs; this also means that the API token will not travel with the workbook if you email it to someone else, for example."
which is great - but we would like to understnad more how this works. what is the "secure credentials store"? how does it interact between the PBIX (PBID) and PBIS?
Hi Anonymous,
I see, hopefully this article https://docs.microsoft.com/de-de/power-bi/whitepaper-powerbi-security will help. The for you relevant part starts at https://docs.microsoft.com/de-de/power-bi/whitepaper-powerbi-security#data-at-rest.
English:
https://docs.microsoft.com/en-us/power-bi/whitepaper-powerbi-security#data-at-rest
Thank you, this is useful.