Box Status

Assistance Required for Power BI and BOX Integration

フォローする
新規投稿
manicka sudhan kandasamy

Hi Team,

We successfully generated a Bearer Token using the M Query language and had it verified by a programming expert, confirming the query is correct in Power BI. However, we were unable to access the files in BOX from Power BI Desktop.

Issue Encountered in Power BI:
item(404) - File not found

We request your assistance in resolving this issue.

Note: This testing is being conducted in the SANDBOX-DEV Admin Console. I have full admin rights to:

  • Create folders
  • Upload files
  • Create new apps and authorize them

Further Mail Communication: <personal information-redacted>

Useful Links:

USER_ID: <personal information-redacted>

Please let me know if you require any additional details.

Regards,

Sudhan

1

コメント

4件のコメント

日付 投票
  • james allen
    • 編集済み

    Hello,

    This is a common issue when connecting Power BI to external APIs like Box, especially when dealing with authentication and file access. Here's a breakdown of potential causes and troubleshooting steps, focusing on the "item(404) - File not found" error:

    1. Verify the File ID and Path:

    Double-check the File ID:
    The most common reason for a 404 error is an incorrect file ID. Ensure you're using the correct ID from Box.
    Confirm that the file hasn't been moved or deleted within Box.
    Check the File Path (if applicable):
    If you're using a path-based approach, verify the path is accurate and that all folders in the path exist.
    Be mindful of case sensitivity in file and folder names.
    Box API Limitations:
    Some Box API endpoints might require specific file types or locations. Check the Box API documentation for any limitations.
    2. Authentication and Authorization:

    Bearer Token Scope:
    Confirm that the Bearer Token you generated has the necessary scopes to access the files you're trying to retrieve.
    Ensure the app associated with the token has the correct permissions within your Box Admin Console.

     

    Best Regards

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

     

    SunPass com

    0
    コメントアクション パーマリンク
  • manicka sudhan kandasamy

    Hi Troy/James

    I saw your updated comments. We already tried the same approach, but it didn’t work as expected. Hence, I request a call so that we can demonstrate the issue with a new app creation and File ID folder structure to resolve it quickly. I suggest setting up a call on Tuesday at 10 PM IST (OR) you please suggest a time on Tuesday, We can plan for it accordingly.

    Regards,

    Sudhan

    0
    コメントアクション パーマリンク
  • manicka sudhan kandasamy

    Hi Troy,

    Kindly, setup a call tomorrow 10PM IST (Tuesday) and share the meeting invite.

    Regards,

    Sudhan

    0
    コメントアクション パーマリンク
  • manicka sudhan kandasamy

    Hi Troy,

    I had requested a call at 10 PM IST (Tuesday) in my earlier comments, but I believe we missed that time.

    Could you please set up a call at your convenience between 10 AM IST and 10 PM IST on a weekday this week and share the meeting invite?

    Regards,
    Sudhan

    0
    コメントアクション パーマリンク

サインインしてコメントを残してください。