how to transfer table info to excel

Question

hi Guys,

I'm trying to read data from the confluence page with Excel Power Query (company intranet). The page needs a registration.

I've tried a few things with web connectivity but it doesn't work.
does anyone have experience how to do this correctly?

Thanks in advance

menschlich · Answer

Hi Florian thanks for your answer,
hmm ... does not work, I also tried Power Bi and nothing
why does it have to be so complicated.
I don't know about API, that would be a possibility

Florian_8erf7n · Answer

Try if basic auth works.

https://username:password@yourserver/confluence/....

If you need to share the excel file it’s best to have a dedicated user account with limited permissions. For a first shot you can use your own credentials.