How to connect to a local system which login are required

[Anonymous]

Hi, my company had self developed a system that compile daily report. This system required login for access. I have tried to key in login details in Access Web content, but failed. Everytime put in the web address in Get Data, it just lead me to the login page. Is that possible for power bi to access the system and grab the report?

[v-yuezhe-msft]

@Anonymous,

What error message do you get in Power BI? What type of authentication does your system use, basic or OAuth?

Regards,
Lydia

[Anonymous]

@v-yuezhe-msft,

Type of authentication used is basic.

I'm not sure what kind of access web content that i should use. I tried each, and the error message is "The credentials provided are invalid."

[v-yuezhe-msft · Accepted solution]

@Anonymous,

You can specify the authentication in Headers of Power Query code as described in the following similar thread.

https://community.powerbi.com/t5/Integrations-with-Files-and/Connect-to-restful-api-data-source-multiple-times/td-p/138855

Regards,
Lydia