Forum Discussion
Data refresh fail
I have three different sources in the data set. They are all set to Organization permission levels and signed in under me. Two sources are from the same sharepoint site one of which is the Excel document posted on sharepoint causing this refresh error. The third source is from a different site that seems to have no issues.
Hi ConnorH,
If you are work with a mixed data source with both on premise and online types, I'd like to suggest you take a look at the following link to enable the use gateway to handle cloudy data source options. (cloudy data source does not need to add into the gateway data source, you only need to turn on the option allow gateway to manage them in mixed datasets)
Merge or append on-premises and cloud data sources
Regards,
Xiaoxin Sheng