Forum Discussion

WhiteBusLady's avatar
WhiteBusLady
Frequent Visitor
7 years ago
Solved

No Gateway

After all I've read about how simple OneDrive hourly refreshes are, and all I've learned about self-service PowerQuery data prep with calculated columns and measures, I'm horrified to finally realize I cannot do simple data updates to my fancy reports without a Gateway! 

 

My client has 3 principals, working from separate coasts.  All company data flows to shared OneDrive folders.  There is no local network.  No server.  No always-on computer.  Isn't that the point of Office 365 and OneDrive?  Is there no way to do a simple daily data update without a server-based Gateway?  What am I missing? 

 

Is there some way to script something that will accomplish the same thing? 

  • Hello, 

     

    You can install personal data gateway in your machine and you also need to connect your one drive to your pc as well, them just schedule a refresh on a time the machine will be on. 

     

    Regards!

    ED

6 Replies

  • Hello, 

     

    You can install personal data gateway in your machine and you also need to connect your one drive to your pc as well, them just schedule a refresh on a time the machine will be on. 

     

    Regards!

    ED

    • WhiteBusLady's avatar
      WhiteBusLady
      Frequent Visitor

      Thank you for the reply.  I had to do some reading....

      Superficially, this makes sense if you have a Windows machine that is always online.  I am developing the reports on a Windows laptop, but my presence is temporary.  I will be moving on to other projects.

      My client has 3 PBI users geographically separated, no internal network, all using Macs.  They interface with one of their large clients using Office365.  The plan was to use OneDrive and PBI to share daily/weekly reports.  I read that the Gateway runs on Windows.  What about a Mac-based Gateway?  If I was logging in with an Apple machine would I be offered a Mac version?

      I downloaded the Gateway softeware and need to do some experimenting before I mark this as solved.  Will be back....

      • WhiteBusLady's avatar
        WhiteBusLady
        Frequent Visitor

        This works.  But I still have nowhere to run it.  I am only online now and then.  The office people only have Mac hardware.  We work together through Office 365.

         

        Is there a Mac version of the gateway program?  Either personal or standard?