Forum Discussion
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 same file but with a comma as delimiter, everything works fine. However, due to external reasons I really need to be able to import it with the semicolon as delimiter.
Is this perhaps tied to my regional / language settings?
Is there any way to import a semicolon-delimited file from Onedrive to Power BI?
Note: I know I can import the file in the desktop version, but I need the automatic refresh function from OneDrive that will also work when my PC is not connected to the net.
Thanks in advance for your help!
Jeroen
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
2 Replies
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
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
