Forum Discussion

jvanhemelen's avatar
jvanhemelen
Frequent Visitor
7 years ago
Solved

Semicolon delimited CSV file from OneDrive cannot be imported

Hi,   I'm trying to import a CSV file from my company OneDrive, but I'm receiving the error below.     This CSV file is using a semicolon (;) as delimiter. When trying to import the exact...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    HI jvanhemelen ,

    How did you get data from that file? Onedrive connector or csv connector?
    If onedrive connector, I'd like to suggest you to use web connector to get data from onedrive url and package it as csv connector and modify analysis type as semicolon format.

    Use OneDrive for Business links in Power BI Desktop

    Regards,

    Xiaoxin Sheng

Anonymous's avatar
Anonymous
Not applicable
7 years ago

HI jvanhemelen ,

How did you get data from that file? Onedrive connector or csv connector?
If onedrive connector, I'd like to suggest you to use web connector to get data from onedrive url and package it as csv connector and modify analysis type as semicolon format.

Use OneDrive for Business links in Power BI Desktop

Regards,

Xiaoxin Sheng

  • jvanhemelen's avatar
    jvanhemelen
    Frequent Visitor
    7 years ago

    Hi Xiaoxin,

     

    That seems to be a workable workaround, thanks!

    I have meanwhile found an alternative solution in my organization by using live queries on SQL, but this will for sure come in handy next time I have a similar issue.

     

    Best regards,

    Jeroen