Failure to load data in csv format from OneDrive Business

[sammy_mcd]

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?

[v-yuezhe-msft]

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