Forum Discussion

L_trainee's avatar
L_trainee
Frequent Visitor
1 year ago
Solved

Desktop work, but error in WorkSpace: File contains corrupted data [...]

Hello,   I've set up a Power BI process, loading data (excel listings) from SharePoint Library folders to a dashboard.   It works perfectly in Desktop version (load data and refresh the dashboard...
Need Help
  • Akash_Varuna's avatar
    Akash_Varuna
    1 year ago

    Hi L_trainee I think your next steps will help pinpoint the issue. Converting the files to CSV and inspecting them with a notebook can reveal hidden inconsistencies like invalid characters or formatting issues. Creating a separate query for these files will allow you to test their compatibility with Power BI Service independently. If merging works after isolating the issue, it confirms the problem lies in file structure or formatting.

v-saisrao-msft's avatar
v-saisrao-msft
Community Support
1 year ago

Hi L_trainee,
I wanted to check if you had the opportunity to review the information provided by Akash_Varuna . Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.