Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
7 years ago
Solved

error when reading file from Sharepoint

I uploaded .xlsx file into Sharepoint (or One Drive - I am not able to differentiate this), then accessed this data with Power BI Desktop - get data from Sharepoint folder. When trying to refresh I u...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    Hi

     

    Let me close this thread. Data are confidential so I couldnt share.

    But the issue is somewhare in data. My remarks:

    Excel on local drive is not read the same way as the same excel uploaded to sharepoint OR excel uploaded to sharepoint is converted causing Power BI cannot read data returning error. Of course it happens in specific cases which I cannot describe here because I couldnt find the row/s in data responsible for the error. 

     

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Anonymous,

Could you please share the Excel file so that I can test?

Regards,
Lydia

Anonymous's avatar
Anonymous
Not applicable
7 years ago

Hi

 

Let me close this thread. Data are confidential so I couldnt share.

But the issue is somewhare in data. My remarks:

Excel on local drive is not read the same way as the same excel uploaded to sharepoint OR excel uploaded to sharepoint is converted causing Power BI cannot read data returning error. Of course it happens in specific cases which I cannot describe here because I couldnt find the row/s in data responsible for the error.