Forum Discussion
Data Format Error in Powerbi Service
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.
But i am using the the sharepoint file connecter in my powerbi desktop it all works fine in the dekstop as expected but as soon as in the service it crashes with this error on refresh , And actually i have a lot of sheets in my excel file and the data is also huge so how do i find that ndash and replace , can u guide me if i am using the wrong connected for it which is causing the error
Thanks
Hi Batman020,
Sorry, I'm now confused. Are you using XML files as your source, or are you using Excel files?
I am using excel files as my source and they are stored in my onedrive and through there i am accessing it
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.