Solved: unable to read an excel file from OneDrive/share p...

Ghanshyam_Kumar · ‎02-23-2023

I am unable to read an excel file from OneDrive/share path in power bi dataflow. Please find the below error msg.

ibarrau · ‎02-23-2023

Hi. Can you check the extension of the file? that error is usually for xls files. If you are using dataflow the best would be reading xlsx files because the old format might need special plugin to install in local machine. That wouldn't be great for dataflows.

I hoep that helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

View solution in original post

ibarrau · ‎02-23-2023

Hi. Can you check the extension of the file? that error is usually for xls files. If you are using dataflow the best would be reading xlsx files because the old format might need special plugin to install in local machine. That wouldn't be great for dataflows.

I hoep that helps,

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Happy to help!

LaDataWeb Blog

unable to read an excel file from OneDrive/share path in power bi dataflow

Helpful resources

Power BI Monthly Update - September 2024

Microsoft Fabric & AI Learning Hackathon

Fabric Community Update - September 2024