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

vrossouw's avatar
vrossouw
Helper III
9 years ago

Hi , thanks for the info below.  I have now set up the gateway correctly (I think), but BI doesn't like my source.

I am going to try to let the source be One Drive, which data source type should I select?

(Get data from One drive, and use Power BI desktop and gateway)

 

Thank you

 

Anonymous's avatar
Anonymous
Not applicable
9 years ago

Hi vrossouw,

I am not sure that how you connect to the data source from Power BI. If you directly connect to Excel files stored in OneDrive, gateway is not required and you don't need to add data source under gateway. For more details, please review this article:https://powerbi.microsoft.com/en-us/documentation/powerbi-refresh-data/ .

In addition, have you checked the computer that install personal gateway?



Thanks,
Lydia Zhang

  • vrossouw's avatar
    vrossouw
    Helper III
    9 years ago

    Hi,  I have read the info on connecting to One Drive. My understanding is that , to auto refresh dashboards, you should connect to One Drive directly through the BI service?  I am currently designing the dashboards on BI desktop, and then publish to the service.

     

    I think the Service don't have all the design functionality , the same as designing on the Desktop? For example, when I pull my files from the source, I first need to make changes in query editor. I don't see the query editor on the service? 

     

    Currently my data is sitting on a shared drive, as someone else is refreshing my SAP BW reports every morning. (The data can't be on my local drive.)

     

    Thanks in advance.

    • 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 Lydia , thanks for your time on this.

         

        I think I am missing a step.... how do I refresh service , without the gateway?