Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Gateway from Shared Local Folders Error (Scheduled Refresh)

Hi Everyone 🙂

 

I am in a fight to get these data live via gateway we :

 
 

I have a SQL server up and running, yet the local shared folder files arenot added to the gateway and gives me UnathorizedAccess Error.

 

How can I eliminate this Error?

And do I need to add all data to the gateway to schedule refresh? Can't i schedule partial refresh based on the SQL Server thats already in the gateway?

 

Br,

AS

Need Help
Tips and Tricks

4 Replies

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi Anonymous ,

     

    If this Shared Local Folders source is an on-premises data source and used in query(such as connecting it in query editor) , we need to configure it to gateway to make refresh work. If you are using a standard mode gateway, please add a data source in "Manage Gateway" and configure correct credential, then map your source in setting of this dataset. If you are using a personal mode gateway, please configure the credential under the setting of this dataset. If you have other cloud data source and merge/append with other on-premises  sources, we also need to configure this cloud data source in gateway, but if the query of cloud data source is standalone, we do not need to configure a gateway for it. Please refer to this document: https://docs.microsoft.com/en-us/power-bi/refresh-data#review-data-infrastructure-dependencies

     


    Best regards,

     

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    Hi  Anonymous ,

     


    Does this issue have been resolved?Could you please provide more details about it If it still not be resolved? Please don't contain any Confidential Information or Real data in your reply.

     


    Best regards,

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Thanks for your support -- can you join me for a quick zoom session?

      • v-lid-msft's avatar
        v-lid-msft
        Icon for Community Support rankCommunity Support
        6 years ago

        Hi Anonymous ,


        Sorry for that, but we cannot provide support outside the forum. Have you tried to configure data source for Local Folders in "Manage Gateway"?

         

        If it is an urgent issue, We suggest you to open a ticket here for help if you are a pro user: https://powerbi.microsoft.com/en-us/support/


        Best regards,