+ Reply to Thread
Results 1 to 2 of 2

Power Query issue access forbidden

  1. #1
    Registered User
    Join Date
    05-14-2020
    Location
    Mauritius
    MS-Off Ver
    Office 365
    Posts
    84

    Power Query issue access forbidden

    Hello,

    we got a problem in our company with a query built from a colleague. The query takes data from several files. All files are on sharepoint. Also the query file.
    For the colleague who built the query all is fine and working. For me and another colleague with the same access rights we get an error message that the access to the resource file is forbidden.
    Can someone explain what is wrong here?
    Greetings

    Tor


  2. #2
    Forum Expert CK76's Avatar
    Join Date
    06-16-2015
    Location
    ONT, Canada
    MS-Off Ver
    Office 365 ProPlus
    Posts
    5,522

    Re: Power Query issue access forbidden

    There can be few reasons...

    1. Users are on different organization tenant.

    2. Data Security is set to Private. It should be set to Organizational or Public. This is set in Power Query. Query Editor -> Data Source settings -> Edit Permission

    3. In correct credential is supplied to query. This is also in same location as above, under Credentials.
    “Progress isn't made by early risers. It's made by lazy men trying to find easier ways to do something.”
    ― Robert A. Heinlein

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. [SOLVED] How to access data via VBA from a Connection Only Power Query query.
    By MLAN_75 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 05-14-2020, 11:45 AM
  2. STDEV formula issue in Power Query Table
    By hawkdaddy404 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-06-2020, 04:22 PM
  3. Excel Power Query Refresh or Access Query - 2nd Query Run is faster
    By Steveapa in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 01-03-2020, 10:16 AM
  4. Sub-Forum for Excel Power Tools (Power Query, Power Pivot & Power BI)
    By chullan88 in forum Suggestions for Improvement
    Replies: 10
    Last Post: 06-28-2018, 02:25 PM
  5. Power Query import issue
    By kao in forum Excel General
    Replies: 30
    Last Post: 01-13-2018, 06:13 PM
  6. Power Query Issue
    By TheDtox in forum Excel Formulas & Functions
    Replies: 19
    Last Post: 12-27-2017, 05:43 AM
  7. Power Query Issue
    By TheDtox in forum Access Tables & Databases
    Replies: 3
    Last Post: 12-27-2017, 02:28 AM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1