December 2017 On Prem Gateway supports Mashup of Different Sources?

[edhans]

It seems the December 2017 On Premesis Gateway now supports mashup of data in Power Query. I was in a report that I have been having to update manually every few days and upload that has some data from our on prem SQL server and some from a CSV file hosted on Sharepoint.

I notieced that "Schedule Refresh" was available, selected my data gateway and confirmed my SharePoint credintials and it seems to work.

But the Dec blog post doesn't mention this at all, so wondering if this is supported, if there are issues I should look out for, or if this was just skipped in the announcement?

[v-qiuyu-msft]

Hi @edhans,

Does the CSV file hosted in SharePoint online? 

You can see PG comment in this idea, 

The initial support will enable refreshing datasets that connect to Online and On-prem sources but that do not “mash up” data between them (i.e. no Merge/Append or other query references involved). We will enable full mashup scenarios in a second phase, coming later this year.

Best Regards,
Qiuyun Yu 

[edhans · Accepted solution]

Yes, it is sharepoint online. It seems to actually work once or twice, then the portal where I scheudule refreshes loses the connection to the Sharepoint site (authentication) so then stops working. Flakey at best. I see it is in progress and have been following that thread. Voted on it back in April or May 2017 when I discovered the issue.

Hoping for January 2018 full support!