Forum Discussion

dimazaid's avatar
dimazaid
Icon for Microsoft Employee rankMicrosoft 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
Icon for Microsoft Employee rankMicrosoft 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
      Icon for Microsoft Employee rankMicrosoft Employee
      9 years ago

      Anonymous,

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

       

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Any updates?