Skip to main content
cancel
Turn on suggestions
Auto-suggest helps you quickly narrow down your search results by suggesting possible matches as you type.
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Sokon

Gateway data refresh fails when data is merged from web and on-prem sources

Submitted by Advocate V on ‎01-03-2019 06:07 AM

Datasets that include a query that merges data coming from a web data source on one side and another set of data coming from an on-Premises data source can't be refreshed using the On-Premises data gateway.

Error messages depend on the kind of the web data source. For example:

  • Sharepoint Online List: "The credentials provided for the SharePoint source are invalid"
  • Excel in Sharepoint Online (Web Connector): "SharePoint: Request failed: https://[...]"

I tried to merge data

  • from On-Prem Oracle with SPO List
  • from On-Prem Excel with SPO List
  • from On-Prem Excel with Excel in Sharepoint Online (Web Connector)

Every attempt failed. Tested with On-Prem Data Gateway 12-2018. I followed this documentation. According to this announcement this should work.

 

However, refreshes succeed when I access the identical data sources with reports that do NOT merge the data in a query:
Merge Test Result.png

 

Status: New
See more ideas labeled with:
21 Comments (21 New)
Comments
Sokon
Advocate V
Advocate V
‎05-25-2020 08:13 AM

Hi @I_B , no news here. However, with the arrival of Dataflows we now import the on-prem data into a Dataflow to cache it. Then, we join that Dataflow to the data from the cloud in the Data preparation/M step. Because then it's both cloud data and therefore the merge works. Hope this helps you, too!

Idea Statuses