Forum Discussion

Batman020's avatar
Batman020
New Member
10 months ago
Solved

Data Format Error in Powerbi Service

I am Getting the Following Error while refreshng in powerBi service . I have a bunch of file all are coming from the sharepoint folders.But from where can i check this error it doesnot state the docu...
  • tayloramy's avatar
    tayloramy
    9 months ago

    Hi Batman020, 

     

    If you're using Excel files and not XML files, there is no need to do any XML parsing. Use the Excel file connector, or the Web or SharePoint Folder connectors to connect and parse the Excel file directly.  

    If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.

Batman020's avatar
Batman020
New Member
9 months ago

I am using excel files as my source and they are stored in my onedrive and through there i am accessing it 

 

tayloramy's avatar
tayloramy
Super User
9 months ago

Hi Batman020, 

 

If you're using Excel files and not XML files, there is no need to do any XML parsing. Use the Excel file connector, or the Web or SharePoint Folder connectors to connect and parse the Excel file directly.  

If you found this helpful, consider giving some Kudos. If I answered your question or solved your problem, mark this post as the solution.