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

[Anonymous]

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

[venal]

@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]

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]

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

[GilbertQ]

Hi there

What you would need to do is to use it via the Web Connector.

Here is a post where it explains on how you can do it https://docs.microsoft.com/en-us/power-bi/desktop-use-onedrive-business-links

[Anonymous]

If i use it from Desktop it works fine the issue is with the Power BI Service. Please see the video in the main post

[GilbertQ]

Hi there

Did you try and use the link above to get it working?

[Anonymous]

Same error status code 500

[GilbertQ]

I did read somewhere that you might have to be an Owner on the site.

Can you confirm your permissions?

[Anonymous]

What do u mean by owner on the site ? Is it the Power BI Workspace you are talking about or the OneDrive Business directory ?

Where do i check the permissions ?

[GilbertQ]

Hi there

It will be on the OneDrive Directory, where you should have the permissions of Owner

Here are more details on how to find out the permissions: https://answers.microsoft.com/en-us/msoffice/forum/all/permissions-sharing-and-synching-for-onedrive...

[Anonymous]

Thanks for the link but this folder with file is not shared as such with anyone and this is my business account where all the files exist and i have created them so it shows me as the owner

[GilbertQ]

I am then not sure why it is not working.

I can use files from OneDrive for Business with no issues.

Can you post details from the Query Editor on how you are connecting to the file?

[GilbertQ]

Hi there

Could you confirm that you can open up the file from OneDrive online?

[Anonymous]

Yes I can since its my business account.