how to transfer table info to excel

[menschlich]

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

[Florian]

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. 

[menschlich]

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