Forum Discussion

vrossouw's avatar
vrossouw
Helper III
9 years ago
Solved

Personal Gateway - Stand alone computer

Hi , I have set up a personal gateway - to automatically refresh our Manufacturing Dashboard. My Gateway shows that the computer is online.         The Scheduled refresh shows that the ...
  • vrossouw's avatar
    vrossouw
    9 years ago

    Hi

    My problem is solved.

     

    I saved the files to One Drive, and then use the Gateway to refresh (publish) to the Power BI service.

     

    Thanks

    Vicky

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi vrossouw,


You can connect to Excel file that stored in Onedrive from Power BI Desktop, then create reports in Desktop and publish them to Service. This way, when you refresh the dataset in Service, gateway is not required.

Thanks,
Lydia Zhang

vrossouw's avatar
vrossouw
Helper III
9 years ago

Hi

I want to eliminate the "publish to service" step, that is why I thought of setting up the gateway.

 

Someone else in my company is refreshing the excel reports, and then BI  must  automatically publish to the service.

 

Thanks in advance

V

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi vrossouw,

    Gateway is used to refresh dataset in Power BI Service, it cannot be used to automatically publish report to Service. If you need to directly connect to Excel file on Onedrive in Power BI Service,  you can use "Get Data>Files>OneDrive - Business(OneDrive - Personal)" option.

    Thanks,
    Lydia Zhang

    • vrossouw's avatar
      vrossouw
      Helper III
      9 years ago

      Hi

      My problem is solved.

       

      I saved the files to One Drive, and then use the Gateway to refresh (publish) to the Power BI service.

       

      Thanks

      Vicky

      • Anonymous's avatar
        Anonymous
        Not applicable
        9 years ago

        Hi vrossouw,


        Glad to hear the issue is resolved. You can accept helpful replies as answer, this way, other community members who have similar issues will easily find the solution.

        Thanks,
        Lydia Zhang