Not able to connect to CSV file on OneDrive Personal

[jrmchlt]

Hi,

When trying to establish connection with a csv file hosted on my Onedrive personal account, it terminates unsuccessfully with error message: (sorry it's in French)

Nous n'avons pas pu importer les données depuis OneDrive - Personal

ID d'activité2ab2c338-504c-4b8a-548a-d1203b0f6694

ID de demandec53c6a6f-10db-b6d2-44f8-0bd71c6ae5dd

ID de corrélationf4dcc589-ec91-cce4-80cd-614d6776c2af

Code d'état400

HeureSat Feb 25 2017 15:36:15 GMT+0100

Version13.0.1700.1256

URI du clusterhttps://wabi-north-europe-redirect.analysis.windows.net

I'm logged in with my enterprise account on Power BI, with my personal ID on Onedrive, but does not look as a root cause given what I found on PowerBI KMDB.

Note: it does not work either with my OneDrive Enterprise.

Anyone has an idea of possible cause for this failure?

Thanks in advance for help and support.

Kind regards,

Jerome

[Anonymous]

Hi @jrmchlt,

I can successfully connect to CSV file located at OneDrive from Power BI Service. In your scenario, please connect to CSV file from Power BI Desktop and check if you get any issues.

To connect to CSV file located at OneDrive for business, please follow the guide that Eno1978 posted.

To connect to CSV file located at OneDrive for personal, please enter the following URL in “Get Data->Web” entry in Power BI Desktop,  replace the bold parts with the resid and authkey that are found by right-clicking on the specific CSV file and selecting “Embed”. And please choose Basic authentication type when connecting to the CSV file.

 https://onedrive.live.com/download?resid=AAXXXX&authkey=AAXXXXXXX&em=x&app=CSV



Thanks,
Lydia Zhang

[Seth_C_Bauer]

@jrmchlt It for sure should be working with your business account... Did you use "Web" as the data source in the Desktop / follow this guide?