topic Re: scheduled resfresh based on a web data source with a key in header in Report Server

scheduled resfresh based on a web data source with a key in header

Muki — Tue, 09 Jan 2018 10:36:25 GMT

I created reports based on web sources ( API within our organisation). One of the web source has a key in the header.

It works perfectly until I want to add the scheduled resfresh option to my report on the report server:

The 'headers' section in which the authorization key is added from my report query disappeared and I can't edit it...

The sections 'connection string' and 'type' can't be edited.

Options in 'authentication type' are :

Windows authentication and Basic authentication which I can't use to enter the key :/

Anyone can help me out with this? None of my queries can be refreshed because of this one web source failure.

thanks a lot in advance

Muki

Re: scheduled resfresh based on a web data source with a key in header

v-qiuyu-msft — Wed, 10 Jan 2018 09:25:57 GMT

Hi Muki,

Based on my test in the latest Power BI report server version 14.0.600.438, we can schedule refresh successfully for the report get data from web data source has key provided. Please try to update report server version to the latest one.

On web portal, we can leave the credential with Anonymous which is same as in Power BI desktop. Then we can create a schedule refresh well.

Best Regards,
Qiuyun Yu

Re: scheduled resfresh based on a web data source with a key in header

Muki — Thu, 11 Jan 2018 09:35:16 GMT

Thank you v-qiuyu-msft

Does the connection string contain the headers in your picture?

I'll ask our administrator to verify the version of our power bi server.

Regards

Muki

Re: scheduled resfresh based on a web data source with a key in header

Muki — Fri, 19 Jan 2018 11:13:10 GMT

Hi v-qiuyu-msft

Our administrator upgraded PowerBi Server into Version 1.1.6582.41691 (October 2017)

But when I open the 'data sources' section for my report, it still looks the same and I get this error message again when I perform the ' test connection' :

Couldn't connect

Re: scheduled resfresh based on a web data source with a key in header

Tariq — Thu, 08 Feb 2018 10:50:47 GMT

Hi Muki,

I have the same error :

The report server couldn't connect to the data source using the information you entered. Make sure you've entered the connection string and any credentials correctly.

With PowerBi Server Version 1.1.6514.9163 (October 2017)

Did you find solution for that ?

Thanks.

Regards,

Tariq

Re: scheduled resfresh based on a web data source with a key in header

Muki — Mon, 26 Feb 2018 12:35:58 GMT

Unfortunately Tariq, I don't have a solution yet for this issue as v-qiuyu-msft didn't react yet.

I'm even not sure whether this functionality is uberhaupt supported by Power BI...

Our admin is trying to install a gateway to our Power Bi Server account. We'll see whether that will resolve our issue.

Re: scheduled resfresh based on a web data source with a key in header

curtis — Tue, 07 Aug 2018 15:22:19 GMT

Has anyone gotten this working yet?

I've got the same issue, with the latest (as of last month, July) code which I downloaded from Microsoft's site and installed.

URL string doesn't have any authentication key info in it, no way to insert it, and it won't connect. Works fine in Power BI Desktop.