Forum Discussion

jrmchlt's avatar
jrmchlt
New Member
9 years ago

Not able to connect to CSV file on OneDrive Personal

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

2 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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?

  • Anonymous's avatar
    Anonymous
    Not applicable
    9 years ago

    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