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

    @dimazaid Thansk Dima, its working now. But unable to schedule refersh for the report. it is saying it is "connecting directly" and and is asking for "windows" credentials. But since it is SP onprem, shouldnt it use a gateway?

     

    How do i set up refersh using a gateway?

     

     

  • dimazaid's avatar
    dimazaid
    Icon for Microsoft Employee rankMicrosoft Employee
    9 years ago

    Hey TBenders,

    No updates yet. 

    • 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