Forum Discussion
Data refresh fail
Ok. The sporadicness of the fail is what is puzzling. Are you mashing it up with any other data? I wondering if the permission levels (private, organizational, etc.) are off, but that only matters if 2+ sources.
Any more details on the error in the service?
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.
At this point ConnorH I am a bit stumped as to why the Excel file is causing an issue like this. You could test to see if the SharePoint site itself is having an issue by moving the Excel file to a different one. Beyond that, I'd open a trouble ticket.
Ok I will give that a try a little later today otherwise I will open a ticket!
-Thank you
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