Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
sammy_mcd
New Member

Failure to load data in csv format from OneDrive Business

Hi team,

 

I'm having trouble loading a csv file into Power BI (O365) from OneDrive Business. File is 315MB, approx 500k rows. Any advice?

 

 

Failed to import data error message.PNG

 

 

1 REPLY 1
v-yuezhe-msft
Microsoft Employee
Microsoft Employee

Hi @sammy_mcd,

I test the scenario that load a CSV file into Power BI Service from OneDrive for Business and can’t reproduce the above error. I suspect this error is related to that there are too much data in the CSV file causing the import to be timeout. Would you mind sharing me the CSV file so that I can test in my Power BI Service?

Besides, in your scenario, you can connect to the CSV file via Get Data->Web entry in Power BI Desktop, then create reports in Power BI Desktop and publish the reports to Power BI Service.


Thanks,
Lydia Zhang

Community Support Team _ Lydia Zhang
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.