question

JulenSanzolVALORTIC-8747 avatar image
0 Votes"
JulenSanzolVALORTIC-8747 asked ThomasGrubbeMoeller answered

Can i connect a bank account to power bi or any microsoft 365 tool?

Hello there,
Im trying to link my bank account to Microsoft 365 in order to analyze it with Power BI.
Is there anyway to connect power bi directly to a bank account?

I have also discovered "Money in Excel": https://templates.office.com/en-us/money-in-excel-tm77948210
It is an excel template that adds a plugin to connect with bank accounts. But is only avaliable for US.
Is it possible to ask Microsoft permission to use it from a spanish account?

Thank you,

Julen.

power-query-not-supportedoffice-excel-itprooffice-addins-devoffice-scripts-excel-devmicrosoft-365-apps-publishing-dev
5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

emilyhua-msft avatar image
0 Votes"
emilyhua-msft answered emilyhua-msft edited

@JulenSanzolVALORTIC-8747

Money in Excel is what I have learned could allow users to smoothly & securely connect to their bank accounts directly into Excel, so far, I do not find other add-ins or tools to achieve this feature.

If you could download account details your bank’s website allows, you may store them somewhere secure for yourself. Then import the data to into Excel to do some data processing.

Is it possible to ask Microsoft permission to use it from a spanish account?

According to "Who can use Money in Excel?", Microsoft has plans to expand global support for Money in Excel in the future, but now, Spanish bank accounts are still not supported.
You may also submit a feedback in Excel app. Go to File > Feedback > Send a Suggestion. Thanks for your understanding.


If an Answer is helpful, please click "Accept Answer" and upvote it.
Note: Please follow the steps in our documentation to enable e-mail notifications if you want to receive the related email notification for this thread.

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.

ThomasGrubbeMoeller avatar image
0 Votes"
ThomasGrubbeMoeller answered

Hi Julen,

I am currently working on a post for my upcoming freelance blog on DWH and Power BI.
The topic is a how-to on connecting Power BI to banks.

If you are a little API experienced, all the technical needed "ingredients" are available through www.nordigen.com.

I will let you know the second my blog is ready. I expect to launch end of January 2022.

Best regards
Thomas Grubbe Møller
Freelance BI Specialist @ BetterBI.dk

5 |1600 characters needed characters left characters exceeded

Up to 10 attachments (including images) can be used with a maximum of 3.0 MiB each and 30.0 MiB total.