Forum Discussion

Muki's avatar
Muki
Icon for Helper I rankHelper I
8 years ago

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

Hi

 

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

scheduled refresh

6 Replies

  • v-qiuyu-msft's avatar
    v-qiuyu-msft
    Icon for Community Support rankCommunity Support
    8 years ago

    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 

    • Muki's avatar
      Muki
      Icon for Helper I rankHelper I
      8 years ago

      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

    • Muki's avatar
      Muki
      Icon for Helper I rankHelper I
      8 years ago

      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

      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.

       

      The connection string still contain the main string without the headers...

       

      Are you sure the headers are incalculated in your example? Or do I oversee something before this can work?

       

      regards

      Muki

      • Tariq's avatar
        Tariq
        Regular Visitor
        8 years ago

        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