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 m...
scheduled refresh
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

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

        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.