onedrive

[davidebrevi]

Dear community,

I'm experiencing an issue trying to use in a model an excel file coming from OneDrive For Business service.

I'm able to connect to the service, navigate my OneDrive folders, select the file,

but when I select to Import the file, PowerBI say me that it was not possible to import data from OneDrive Business.

I don't understand why, as I have an O365 user, and it's the same user used for PowerBI.

Could you help me?

Thanks a lot

Davide Brevi

[vicestcha]

Hi @davidebrevi,

I'm having the exactly same problem, could you  share with me your solution please? it would be very helpful.

Thanks for your time, Victor.

[davidebrevi]

Dear Victor,

I identified 2 ways:

1. The first is to modify the excel available in my OneDrive for Business,

formatting the range of data in your file as table. It is an excel feature. Here is the description of the feature:

https://support.office.com/en-us/article/Format-an-Excel-table-6789619f-c889-495c-99c2-2f971c0e2370

In this way, you will be able to load the excel using the Power BI Service.

2. The second way, is to load the excel from OneDrive for Business in Power BI Desktop.

When you load data using Power BI Desktop, you don't find OneDrive as source type.

You should use the source type "Web", and in the url you put the url of the excel in PowerBI.

In the following article, you find the description to get the link of the excel.

https://powerbi.microsoft.com/it-it/documentation/powerbi-desktop-use-onedrive-business-links/

I preferred the second way, and now I have my data loaded and refreshed from OneDrive for Business.

Consider that this way, require the setup of the refresh, because data will not be automatically refreshed from OneDrive.

I think that also this article could be interesting for you:

https://powerbi.microsoft.com/en-us/documentation/powerbi-service-excel-workbook-files/

I hope that now is more clear, and more documented. Otherwise, ask me!

Best regards d

[v-haibl-msft]

@davidebrevi

Are you experiencing this same issue for all the excel files in your OneDrive Business?

How about the result if you move this excel file to your local location, and try to get data from Local File instead of OneDrive Business?

BTW, could you please give a screenshot while the issue happens?

Best Regards,

Herbert

[davidebrevi]

I identified the source of the problem.

Data were not formatted as table,

  so PowerBI service was not able to load the data,

  but PowerBI desktop was able to load it.

Unfortunately I can't load data from OneDrive with PowerBI desktop,

or at least, I don't know how to...

Thank you

[Greg_Deckler · Accepted solution]

Do you have a data model in your Excel file?

[davidebrevi]

No, I have only an excel worksheet