Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

Error importing Import Excel data into Power BI from file in Onedrive business account

It gives the error below 

 

Something went wrong
Failed to configure selected file
Please try again later or contact support. If you contact support, please provide these details.
Activity ID: 822fc426-f1fc-4851-8c7a-6cee7f3eac64
Request ID: 8fba72fc-ae9a-554e-a3b7-4317ee6face8
Correlation ID: 408a0303-a670-673a-dc20-58c7da9a644f
Status code: 500
Time: Thu Jan 16 2020 00:47:43 GMT+0530 (India Standard Time)
Service version: 13.0.11888.301
Client version: 1912.4.030
Cluster URI: https://wabi-south-central-us-redirect.analysis.windows.net/

 

You can see the video of issue here https://vimeo.com/386406633

Need Help

14 Replies

  • GilbertQ's avatar
    GilbertQ
    Icon for Super User rankSuper User
    6 years ago
    Hi there

    Could you confirm that you can open up the file from OneDrive online?
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      Yes I can since its my business account.

  • venal's avatar
    venal
    Icon for Memorable Member rankMemorable Member
    6 years ago

    Anonymous 

    Thanks for the error message.

    Can you please clarify few details.

    1. what is the connector you are using? (Ex:- Web)

    2. Connectivity Mode ? (Ex:- Import)

    3. Authentication Mode ? (Ex:- Organizational Account)

    4. Privacy Level (Ex:- Basic, Private, Public)

    5. Excel file extension (.xls/.xlsx)

     

    Have you tried to download the excel file into local machine and tried to re-pro the issue.

     

    If this post helps, then please consider Accept it as the solution to help the other members find it more
    If this post was helpful may I ask you to mark it as solution and click on thumb symbol?

     

    BR,

    venal.

    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      I am using the One Drive Business account for this, i dont get any of these options while using the Power BI Service through the browser, what you are asking is options when we use the files from the Power BI Desktop App.

      • Anonymous's avatar
        Anonymous
        Not applicable
        6 years ago
        If I use the local file option it works but then the sync is dependent on my laptop which I dont want , I want the system to auto refresh the data from one drive business location since it’s a shared file with other users