Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Refresh issue with combined API and excel dataset

Hi All, I'm using a dataset which is a combination of an Excel file (stored locally) and some API connections to a third party site. In the desktop app, I've joined these sources with a date table I...
Need Help
Anonymous's avatar
Anonymous
Not applicable
6 years ago

HI Anonymous,

Did your report mix with multiple types of data sources? (e.g both on-premise and online datasource)  Any advanced operations in your query tables? (e.g. merge, combine, reference other queries...) They may affect the refresh operations and Datasource configurations.
Regards,

Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Hi Anonymous 

Yes the report mixes on-premise excel file and online connections to API. How does this affect the configuration I should use for refresh?

At the moment I've got a gateway connection set up for the excel file and entered web data source credentials separately for the API connections as per below (I have entered credentials as it prompts below):

What's the problem with this- is there something wrong with this configuration? As I said, when I tested each of the datasets separately (local and web) they worked fine. And the report refreshes fine in the desktop version.

 

Thanks!

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    Hi Anonymous,

    Please refer to the following document to turn on 'Allow user's cloud data sources to refresh through this gateway cluster' option to use the on-premise gateway to handle cloudy data sources. (it suitable to manage the report with mixed data source types)

    Merge or append on-premises and cloud data sources 

    Regards,

    Xiaoxin Sheng