Forum Discussion

dimazaid's avatar
dimazaid
Microsoft Employee
9 years ago

Updates to the Web connector

We are currently working on improving the refresh of cloud based data sources. As part of this, one of the changes we have made recently is that new datasets that leverage import from Web pages will ...
Announcement
General Comment
Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi,

Any updates?

I can successfully publish and schedule refresh for Excel file stores in One Drive For Business and also can schedule the refresh for SQL Server on-prem queries.... BUT - not if both (the One Drive for Business and SQL query) are in the same model.

PowerBI Destop works perfectly, but when I publish to service - I have the Gateway error.

But I do have a SQL Server Gateway and it works. I also don't need a gateway for OneDrive for Business Excel file connection

So why they are not working together and hoe to fix this?

Please help...

Thank you

Michael

  • dimazaid's avatar
    dimazaid
    Microsoft Employee
    9 years ago

    Hi Anonymous!

    Sorry for the long delay to respond I missed it previously. 

    The ability to refresh an on-prem data source with OneDrive (using oAuth) is coming really soon. Today you can use the personal gateway to get unblocked, or seperate the 2 data sources. 
    Let me know if that works!
    Thanks,
    Dimah

    • Anonymous's avatar
      Anonymous
      Not applicable
      9 years ago

      dimazaid Hi Dimah,

      OAuth2 works through personal gateway, but the dependency on a personal computer is not reliable.

      Any ETA on supporting OAuth2 in Enterprise Gateway?

      Thank you

      Michael

      • dimazaid's avatar
        dimazaid
        Microsoft Employee
        9 years ago

        Anonymous,

        We're currently working on it and it should be available in the next 1-2 months.