Help... please! Credentials are required to connect to the Web source: Basic Authentication for REST

[Leise]

Hi there,

I have a set of REST Services that I connect to using Web.

The REST Services use Basic Authentication over HTTPS.

When refreshing these services through Power BI Desktop and entering the credentials for Basic Authentication, the data is refreshed correctly with no issue.

I then publish the Power BI report to Power BI Service and I try to set up the Schedule Refresh.

In Data Source Credentials I get the following:
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

When I edit the credentials for Web, select Basic as the Authentication Method and enter the correct User Name and Password I get the following:
Failed to update data source credentials: Credentials are required to connect to the Web source.

If I try and hit the REST Service through a browser and enter the exact same User Name and Password I am authenticated and the web service returns the expected result.

The REST Service is an HTTPS service that is publically accessible.

I have tried everything including switching authentication mechanisms and I even tried to download the Data Gateway to set that up to see if that would make a difference. When I download the Data Gateway and click the EXE nothing happens. I have tried unblocking the EXE, running it in Compatibility Mode and still nothing.

Help... please!

[Leise]

Hi there,

I have a set of REST Services that I connect to using Web.

The REST Services use Basic Authentication over HTTPS.

When refreshing these services through Power BI Desktop and entering the credentials for Basic Authentication, the data is refreshed correctly with no issue.

I then publish the Power BI report to Power BI Service and I try to set up the Schedule Refresh.

In Data Source Credentials I get the following:
Your data source can't be refreshed because the credentials are invalid. Please update your credentials and try again.

When I edit the credentials for Web, select Basic as the Authentication Method and enter the correct User Name and Password I get the following:
Failed to update data source credentials: Credentials are required to connect to the Web source.

If I try and hit the REST Service through a borwser and enter the exact same User Name and Password I am authenticated and the web service returns the expected result.

The REST Service is an HTTPS service that is publically accessible.

I have tried everything including switching authentication mechanisms and I even tried to download the Data Gateway to set that up. When I download the Data Gateway and click the EXE nothing happens. I have tried unblocking the EXE, running it in Compatibility Mode and still nothing.

Help... please!

[v-shex-msft]

Hi @Leise,

Can you please provide more detail information about this? (for e.g. gateway connection mode, use choose which gateway, where the REST service located? on-premise/online)

>> When I download the Data Gateway and click the EXE nothing happens. I have tried unblocking the EXE, running it in Compatibility Mode and still nothing.

Please share more detail content about your testing steps.

Regards,

Xiaoxin Sheng

[Leise]

Hi Xiaoxin,

The REST Service is an online REST Service that is publically accessible.

At this stage there is no gateway in play as I could not get it to install.

So a few questions:

Do I definitely need a gateway to make the scheduled refresh work
If so, what gateway connection mode and settings do I need to use

Many thanks.

[v-shex-msft]

Hi @Leise,

Please provide the detail information about datasource settings of power bi desktop and the dataset setting of power bi service.
Have you used the 'web.page' connector in power query?

If that is a case, you need a gateway to manage the refresh; otherwise power bi will use 'connect live' mode to link your source.

Regards,

Xiaoxin Sheng