Forum Discussion

luisreyes's avatar
luisreyes
Frequent Visitor
4 years ago
Solved

Error in excel connection

I'm trying to desing a dashboard with multiple excel books as data source (i have 3 excel books that are not related and are connected)  , today i received an excel from another company, when i try t...
Need Help
  • Vijay_A_Verma's avatar
    Vijay_A_Verma
    4 years ago

    Looks like they have used coding to create the Excel file and some xml is missing in this created Excel. This happens frequently when third party code is used to prepare an Excel file.

    Only option is to correct this Excel file. You can open this Excel file in Excel desktop (if you don't have Excel desktop, use Excel online) and save it again as a .xlsx file. This newly saved Excel will be corrected Excel file.

    Now, your file will be allright and you can use this new file to import into Power BI. 

Vijay_A_Verma's avatar
Vijay_A_Verma
Most Valuable Professional
4 years ago

Looks like they have used coding to create the Excel file and some xml is missing in this created Excel. This happens frequently when third party code is used to prepare an Excel file.

Only option is to correct this Excel file. You can open this Excel file in Excel desktop (if you don't have Excel desktop, use Excel online) and save it again as a .xlsx file. This newly saved Excel will be corrected Excel file.

Now, your file will be allright and you can use this new file to import into Power BI.