Forum Discussion

CMMkamil's avatar
CMMkamil
Frequent Visitor
6 years ago

Why do I get a DataFormat.Error when data source is Sharepoint?

Hello,   I'm relatively new to Power Bi and I'm currently playing around with it trying to teach myself how to use it.    I came across a problem where If I go to refresh the data I get the follo...
Need Help
v-yingjl's avatar
v-yingjl
Community Support
6 years ago

Hi CMMkamil ,

You may use the early versions of Excel workbooks (.XLS files of type Excel 97-2003), it will cause problems sometimes.

You can try the latest version of Excel and open .XLS file, save it as .an XLSX file to try again.

 

Refer the Microsoft document:

https://docs.microsoft.com/en-us/power-bi/desktop-access-database-errors

 

Best Regards,

Yingjie Li

 

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

  • CMMkamil's avatar
    CMMkamil
    Frequent Visitor
    6 years ago

    Hi v-yingjl,

     

    Thanks for your response however, I have already gone through this link and the document is saved as .xlsx

     

    Regards,

     

    Kamil

    • nmasood90's avatar
      nmasood90
      New Member
      6 years ago

      Hi CMMkamil  did you ever find a solution? I am facing the exact same issue.

      • CMMkamil's avatar
        CMMkamil
        Frequent Visitor
        6 years ago

        Hi nmasood90 

         

        Unfortunetly I haven't yet, sorry.