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.  Online

 

 

 

The Scheduled refresh shows that the gateway computer is offline.

 

 

 

If I go to Data Source Settings, and add the folder where the excel files are saved in, I get the 'invalid connection credentials ' message.   (the folder is on a shared drive on our company network)

 

Do you have any ideas on how this can be fixed - so that the auto refresh will work?

Thank you in advance 

 

 

  • 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

12 Replies

  • Greg_Deckler's avatar
    Greg_Deckler
    Community Champion
    9 years ago

    You can check the authentication settings for your connection. However, I am not certain that network shares are supported with the gateway. What happens if you move/copy the folder to the local drive?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    Hi vrossouw,

    Do you use Power BI personal gateway or on-premises gateway to schedule refresh for your dataset in Power BI Service?

    Based on your first screenshot, the refresh fails due to that your personal gateway is offline. Please go to Settings->Datasets, find your problem dataset, then expand Gateway Connection tab, check which server that has personal gateway is installed, make sure this server is not asleep or turned off and is on and connected to the network, otherwise the personal gateway will be offline. Moreover, you can follow the instructions in this article to set up personal gateway.



    Based on  your second screenshot, you are trying to add data source under on-premises gateway and wants to use on-premises gateway to set refresh for your dataset. If that is the case, please check authentication as other post.

    In addition, why not put excel files to OneDrive and connect to the OneDrive data source? This way, gateway is not required and Power BI will automatically refresh your dataset.

    Thanks,
    Lydia Zhang

    • 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