#AcumaticaTnT Acumatica and Excel OData Credentials on Local Computer

Yesterday we covered how to connect to Acumatica OData using Power Query (Power BI) in Microsoft Excel. Here is the recording of the live broadcast:
https://www.augforums.com/live10

During the live broadcast, there was some concern in the chat that the Acumatica credentials get stored in the Excel file.

So I wanted to clarify that they do not. Rather, they get stored on your local computer. That means, if you email the Excel file, the credentials don't follow the file.

The credentials get stored here on your local computer:

C:\Users\<username>\AppData\Local\Microsoft\Office\16.0\PowerQuery\User.zip

Here's a quick video for you skeptics out there. Hopefully this will convince you 🙂

Regarding how the credentials are stored on your local computer, they are encrypted somehow. I mean, it's a high profile Microsoft product so it should be pretty good. I don't understand the details personally, but you can read more about it here:
https://docs.microsoft.com/en-us/power-bi/guidance/whitepaper-powerbi-security