Forum Discussion

SamQC's avatar
SamQC
Icon for Advocate I rankAdvocate I
4 years ago
Solved

Dataflow-Access to the path denied

Hi everyone,

 

I am just getting started with the dataflow but I am already encountering some problems.

  • I want to import data that is located on our company's server
  • A standard gateway is installed on that server
  • When I connect to a folder containing many csv files, it works just fine

Howerver, when I want to connect to a simple Excel file, the following message appears: "An exception occured: Access to the path [...] is denied"

 

Can anyone tell me what is it due to and how can I solve this issue?

Thanks !!!

Dataflow
Need Help
  • arvindsingh802's avatar
    arvindsingh802
    4 years ago

    It seems the file is in sync folder of DropBox
    Please place that file to nomal folder and then create the connection
    Also if the gateway is hosted on different server from File hosting system, please follow gauthamboppana  suggetion as well.

4 Replies

  • arvindsingh802's avatar
    arvindsingh802
    Icon for Community Champion rankCommunity Champion
    4 years ago

    It seems the file is in sync folder of DropBox
    Please place that file to nomal folder and then create the connection
    Also if the gateway is hosted on different server from File hosting system, please follow gauthamboppana  suggetion as well.

    • SamQC's avatar
      SamQC
      Icon for Advocate I rankAdvocate I
      4 years ago

      Hello arvindsingh802 !
      This is not ideal as not all the users have access to the local folders of the server. But since I do, I am going to do this.
      Thank you very much.

  • gauthamboppana's avatar
    gauthamboppana
    Icon for Solution Specialist rankSolution Specialist
    4 years ago

    SamQC   - Is the file in a shared drive or your local folders in your laptop?  Do not use 'E' drive etc. You need to use the UNC path of the folder ('E' will be something like   '\\server2\Corporate\').  Go to ''This PC' > on the 'E' drive right-click > go to DFS tab. There you will find the UNC path.

    Change the Data Source path in Power BI desktop and re-publish to Power BI Service.  And, now you can set up the gateway.

    Hope this helps !


    Did I answer your question? Mark my post as a solution! If not, please feel free to ask me.

    Also, I would ❤ Kudos if my solution helped.  It is a token of appreciation!

    Thank you very much !

     

    • SamQC's avatar
      SamQC
      Icon for Advocate I rankAdvocate I
      4 years ago

      Thank you very much gauthamboppana for your answer!

      Yes. I confirm that I used the UNC path. In my case, I used the "\\10.0.0.5\DropBox" instead of the "G:" drive. 

      But it still doesn't work...

       

      It works only for folders. Not for simple Excel files...