Forum Discussion

Batman020's avatar
Batman020
New Member
9 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.

Anonymous's avatar
Anonymous
Not applicable
9 months ago

Hi Batman020,

 

Thank you for reaching out to the Microsoft Fabric Community, and special thanks to @tayloramy  and djurecic  for their prompt and helpful responses.

 

Thanks for the clarification. As @tayloramy  mentioned, could you please confirm whether you're using Excel files stored on SharePoint or XML files as your data source? This will help us determine if the issue is related to the connector being used.

 

Thanks & Regards,

Prasanna Kumar